Data Engineer – Client-Facing
DAS42
Amazon RedshiftAWSBigQueryCloudETLPerlPythonSQLTableau
Data Engineer – III
MedImpact Healthcare Systems, Inc.
full-time
Posted on:
Location Type: Remote
Location: Remote • California • 🇺🇸 United States
Visit company websiteSalary
💰 $95,717 - $169,898 per year
Job Level
Mid-LevelSenior
Tech Stack
AzureCloudETLPythonSQLSSISSwitching
About the role
- Responsible for the development and administration of data pipelines, the data warehouse, and BI tools.
- Transform raw data into meaningful insights.
- Work closely with the business to gather requirements and translate into a viable solution to solve complex business challenges.
- Understand various database technology platforms and data relationships to develop robust reporting and analytic services.
- Adhere to and serve as a data warehouse resource for the organization.
- Present report data in Power BI in a meaningful way, accessible and clear for individuals at all levels of understanding.
- Develop queries, functions, stored procedures, and views to support reporting and data extraction.
- Significant experience developing reports and dashboards using Power BI and up to date with the current version of Power BI and its capabilities.
- Design, develop, and optimize complex SQL Server solutions, including stored procedures, SSIS packages, and views and other database objects.
- Participate in team-based problem solving and multidisciplinary team use of various data-driven process improvement techniques.
- Develop best practice procedures for end users to facilitate the use of reporting tools and applications.
- Practice good software engineering techniques and standards to reduce coding errors and ensure robustness and efficiency of work products.
Requirements
- BS/BA and 6+ years’ experience or equivalent combination of education and experience, and 2 years of SME in respective areas
- Advanced SSIS development skills, including automation, parameterization, and CI/CD deployment.
- Advanced proficiency with ETL Framework, Power BI, and SQL Server Reporting Services (SSRS).
- Advanced SQL Server expertise, including query tuning, indexing, and large-scale performance optimization.
- Advanced Power BI skills, including dataset optimization, security configuration, and enterprise-level deployment.
- Advanced and proven partition switching expertise in SQL Server.
- Advanced expertise in working with Azure DevOps and CI/CD pipelines.
- Familiarity with healthcare data standards (HL7, X12 EDI, HIPAA compliance)
- Strong knowledge of Power BI service.
- Ensure code quality with Test Driven Development/unit testing.
- Proficient in creating complex DAX queries in Power BI Desktop & Report Builder.
- Strong knowledge of Power BI Report Builder tool.
- Real-time data streaming experience
- Experience working with Azure cloud-based data data engineering solutions.
- Proficiency in Python programming language.
- Familiarity with 340B program.
- Preferred: Understanding of data lakehouse concepts
- Strong experience with Azure Data Factory and/or Databricks
Benefits
- Medical / Dental / Vision / Wellness Programs
- Paid Time Off / Company Paid Holidays
- Incentive Compensation
- 401K with Company match
- Life and Disability Insurance
- Tuition Reimbursement
- Employee Referral Bonus
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQL ServerPower BISSISETL FrameworkDAXAzure DevOpsCI/CDPythondata warehousingdata pipelines
Soft skills
problem solvingcommunicationcollaborationdata analysisreportingpresentation skillsattention to detailorganizational skillsadaptabilitycritical thinking
