Requirements
7 or more years of experience in database development and complex ETL data pipeline engineering.
Proficiency in advanced T-SQL programming and developing highly efficient stored procedures.
Experience with Azure Data Factory and SQL Server Integration Services for enterprise data loading.
Experience in extracting data from modern cloud platforms including Snowflake and Microsoft Azure.
Experience with mapping disparate source systems and constructing staged datasets for artificial intelligence teams.
Experience in developing, troubleshooting, and optimizing comprehensive SSRS enterprise reporting solutions.
Excellent verbal and written communication skills to collaborate effectively with business units.
Responsibilities
Architect and implement highly scalable, high-performance ETL data pipelines to populate enterprise repositories.
Write and optimize complex T-SQL stored procedures and database packages to ensure efficient data processing.
Extract critical data payloads from Azure and Snowflake cloud environments into on-premises staging servers.
Construct curated datasets from staged environments and upload them to cloud infrastructures to support AI initiatives.
Execute comprehensive data mapping and translate overarching business requirements into robust technical solutions.
Build, maintain, and apply targeted technical fixes to existing SQL Server Reporting Services business reports.
Diagnose production anomalies and provide continuous operational support to resolve complex database issues.
Founded in 1999, Resourcesoft, Inc. is a leading Technology Consulting and Professional Services organization. Headquartered in Marlborough, MA, the company serves the technology needs of its clients nationwide. Resourcesoft has often been recognized by prominent rating agencies for its exemplary growth and stability. With over two decades of industry experience, the Company has evolved as a front runner in enabling project optimization. We partner with leading organizations to provide technology solutions within the financial, insurance, education, government, publishing, healthcare and pharmaceutical domains. We take pride in mentoring a workforce that is well positioned to respond to the emerging IT trends and needs. With the employees at the crux of every business endeavor, our success is driven by our expertise in pairing the right talent with the best jobs in the technology sector. We forge long term, personalized relationships with our employees to advance their career to the next level. We engage them in technology centric client projects that provide opportunities for them to evolve, innovate and deliver world class products and services. Our career opportunities offer challenging assignments and exposure to emerging and cutting edge technologies. We are committed to providing our employees with the tools necessary to accelerate their career progression, while maintaining a healthy, work-life balance. We are deeply committed to providing a workplace ambience that is both challenging and fulfilling.
Resourcesoft is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
For more information about Resourcesoft and our services, please visit our website.
...Job Title: Mechanical Systems Technician Job Description This role serves as a technical expert for mechanical systems on vehicles and other prototype platforms, ensuring these systems operate efficiently, reliably, and remain ready for testing and evaluation. You...
...helping a busy household run smoothly? A welcoming family with two children, ages 13 and 11, is looking for a reliable Family Assistant to support their active home life. Their 13-year-old son is very active in sports with team practices and activities most afternoons,...
...Description The base salary for this position is$17.19 hourly. Nuzzled within the historic lands of Mauna Lani, our Beverage Cart Attendant will be responsible for serving food and/or beverage on our beautiful Francis I'i Brown golf courses. With the backdrop of...
...another. Core Responsibilities: Assist guests with food and beverage selections: make recommendations, inform of current specials,... ...standards, and contributes to overall cleanliness and organization of cart, snack bar, golf course, and facilities Perform cart set up...
...will assist with the normal day-to-day processing of IT help desk issues in the Albany, GA area. This position is a full-time Summer Internship and will end on August 15, 2023. Candidates must be a great communicator and be willing to assist with computers and phone...