Development

Sr. Data Engineer

Contract

Brooksource

Apply Now

<< Return to Search Results

Sr. Data Engineer (SSIS + ETL + SQL)

Contract or Contract to Hire

100% Remote Forever

Join our team as a Data Engineer/ETL Developer where you will partner with product owners and data consumers to develop, implement, and support business intelligence ETL solutions. In this role, you will collaborate with a team of data engineers and BI Developers who possess a deep healthcare background. You will be an expert in SQL Server Integration Services (SSIS) & SQL programming (T-SQL) with an aptitude for collaboration, clarity, and open communication. You will be accountable for high quality deliverables as an individual contributor. The ideal candidate is proficient at building ETL solutions using the Microsoft stack. He or she should have 4+ years of data warehousing skills with a proven history of success and a passion for technology and applying technology to real business problems. You will enjoy the flexibility to telecommute from anywhere within the U.S. as you take on tough, rewarding challenges.

Our Ideal Data Engineer/ETL Developer Profile:

You are an expert with expansive data engineering/ETL experience. While you have hands-on experience with common tools, frameworks, and paradigms used in data engineering, you can rapidly switch gears to use architecture and tools for the job at hand. To the core, you are a key backend engineer and ETL architect, who has had the opportunity to focus on managing the data related aspects of large-scale healthcare-oriented enterprise backend systems. You understand how diverse types of stakeholders work with data, from product engineering teams to business analysts.

Responsibilities:

• Develop efficient, high performing ETL solutions using SSIS to facilitate data movement consistent with business and data requirements

• Write efficient, high performing advanced/complex T-SQL

• Troubleshoot existing SSIS packages to resolve issues

• Monitor ETL processes associated with QA, UAT, and Production domains – job monitoring on a rotating basis, issue identification, documentation, analysis, and resolution

• Consume data from a variety of sources (RDBMS, APIs, FTPs and other cloud storage) & formats (Excel, CSV, XML, JSON, Parquet, Unstructured)

• Comfortable with using programming such as C#/Regex to overcome complex ETL data transformations

• Analyze business requirements for data feeds and design, develop, and deploy fully automated ETL solutions to produce or ingest the files

• Assist in continuous refinement of best practices for all ETL related activities, including data movement, data quality, and data cleansing

• Provide reliable estimation of work and commit best efforts to delivering work in alignment with those estimates

• Communicate status, dependencies, and issues to the Data Engineering Manager

• Build collegial and effective working relationships with coworkers

Skillset:

• Associates degree in Computer Science, Information Management and/or equivalent work experience.

• 5+ years of ETL experience using SSIS (SQL Server Integration Services)

• 5+ years of T-SQL, writing complex queries, stored procedures and functions, query optimization, performance tuning, and index utilization

• 3+ years of working on large data warehouse projects

• Excellent interpersonal/communication skills (both oral/written) with the ability to communicate at various levels with clarity & precision

• Experience with Agile product development (using tools such as TFS/Service Now)

Nice to have:

• Database Lifecycle Management knowledge

• Deep experience with healthcare data, its standards, and its complex data integrations

• Informatica exposure is a huge plus

• Knowledge of data modelling techniques including slowly changing dimensions, aggregation, partitioning

• Exposure to Kimball or Inmon data modeling methodologies

• Sense of ownership and pride in your performance and its impact on company’s success

Eight Eleven Group provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, national origin, age, sex, citizenship, disability, genetic information, gender, sexual orientation, gender identity, marital status, amnesty or status as a covered veteran in accordance with applicable federal, state, and local laws.

Brooksource provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, national origin, age, sex, citizenship, disability, genetic information, gender, sexual orientation, gender identity, marital status, amnesty or status as a covered veteran in accordance with applicable federal, state, and local laws.

JO-2206-123950

Apply Now

Tagged as: Yes