ETL Developer (with Microsoft SQL Server

BCforward is currently seeking a highly motivated ETL Developer (with Microsoft SQL Server) for a REMOTE opportunity.

Position Title: ETL Developer (with Microsoft SQL Server)

Location: REMOTE

Please note this is the target date and is subject to change. BCforward will send official notice ahead of a confirmed start date.

Expected Duration:6+ Months RTH

Job Type: Contract and Remote ( PST Candidates preferred )

Please note that actual compensation may vary within this range due to factors such as location, experience, and job responsibilities, and does not encompass additional non-standard compensation (e.g., benefits, paid time off, per diem, etc.).

Custom system implementation of a prenatal and newborn screening information system (SIS) to diagnose, treat, and track genetic diseases.

All states have a newborn blood test to screen certain diseases, and this is implementing a more thorough and comprehensive system for CA.

Must Have Skills:

• Writing complex SQL queries, Stored Procedures, Views, and Triggers using T-SQL
• Expert in implementing ETL solution using SQL Server Integration Services (SSIS), Data Lake and Azure Data Factory
• Experience in implementing complex data migration projects, migrating millions of records from different sources.
• Good to have SQL integration services using Azure Synapse
• Working experience in RDBMS skills and Database Design, Normalize and De-normalize techniques.
• Data Modeling using tools like ER-Win
• DB Build Automation using DevOps and SQL Server Data Tools
• Azure SQL and DevOps 2019 experience
• Experience in using DevOps pipelines and Azure stack.
• Expert in writing SQL using PowerShell.
• Good to have SQL Server Analysis Services (SSAS) and Power BI experience.
• Database builds consolidation and deployment activities

Good to have Skills:

• Dynamics Dataverse and Power Platform experience
• SSRS and Power BI knowledge
• Managing large and complex database systems in on-prem data Centers
• Working experience on SQL Database Upgrade projects, migrating databases between data canters
• Familiarity with data analysis, data sciences and analytics
• Strong understanding of data integration issues (validation and cleaning), familiarity with complex data and structures
• Understanding of transformations and data Modeling
• Experience in Agile methodology.

Benefits:

BCforward offers all eligible employees a comprehensive benefits package including, but not limited to major medical, HSA, dental, vision, employer-provided group life, voluntary life insurance, short-term disability, long-term disability, and 401k.

#ETL #MSSQL #Powerplatform #Dataverse #erwin #datamodeling #Azure #Powershell #ADF #AzureDataFactory

Founded in 1998 on the idea that industry leaders needed a professional service, and workforce management expert, to fuel the development and execution of core business and technology strategies, BCforward is a Black-owned firm providing unique solutions supporting value capture and digital product delivery needs for organizations around the world. Headquartered in Indianapolis, IN with an Offshore Development Center in Hyderabad, India, BCforward's 6,000 consultants support more than 225 clients globally.

BCforward champions the power of human potential to help companies transform, accelerate, and scale. Guided by our core values of People-Centric, Optimism, Excellence, Diversity, and Accountability, our professionals have helped our clients achieve their strategic goals for more than 25 years. Our strong culture and clear values have enabled BCforward to become a market leader and best in class place to work.

BCforward is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against based on disability.

To learn more about how BCforward collects and uses personal information as part of the recruiting process, view our Privacy Notice and CCPA Addendum. As part of the recruitment process, we may ask for you to disclose and provide us with various categories of personal information, including identifiers, professional information, commercial information, education information, and other related information. BCforward will only use this information to complete the recruitment process.

This posting is not an offer of employment. All applicants applying for positions in the United States must be legally authorized to work in the United States. The submission of intentionally false or fraudulent information in response to this posting may render the applicant ineligible for the position. Any subsequent offer of employment will be considered employment at-will regardless of the anticipated assignment duration.

Interested candidates please send resume in Word format Please reference job code 220846 when responding to this ad.