Reporting Data Engineer

We are building a B2B product from the ground up using a modern technology stack that makes a real difference for thousands of patients. Our candidate for this role is a subject matter expert well-versed in azure cloud and engineering practices and principles including planning, building, tuning, and maintaining reporting services, technology, and bi workspaces. The Reporting Engineer is responsible for designing, developing, and maintaining business intelligence solutions using Power BI, Azure services, and Python. This role involves working closely with stakeholders to understand their data requirements, transforming raw data into meaningful insights, and ensuring data accuracy and availability. Hybrid Role – 3 days in office (T-TH)

Power BI Development:

• Design, develop, and deploy interactive Power BI dashboards and reports.
• Create data models and establish data connections.
• Implement measures, calculated columns, and DAX queries to support complex data analysis.

Azure Data Services:

• Utilize Azure Data Factory for ETL (Extract, Transform, Load) processes.
• Manage and optimize Azure Data Lake for efficient data storage and retrieval.
• Integrate various azure services (such as Azure Synapse Analytics, Microsoft Fabric) to streamline data workflows.

Python Scripting:

• Develop Python scripts for data cleaning, transformation, and automation tasks.
• Create and maintain Python-based APIs and data processing pipelines.
• Implement machine learning models and algorithms for advanced data analysis.

Data Management and Governance:

• Ensure data accuracy, integrity, and security across all reporting solutions.
• Develop and maintain documentation for data models, configurations, and processes.
• Monitor data quality and troubleshoot issues related to data discrepancies or system errors.

Stakeholder Collaboration:

• Work closely with business users to gather requirements and translate them into technical specifications.
• Provide training and support to end-users on using Power BI reports and dashboards.
• Communicate findings and insights effectively to both technical and non-technical stakeholders.

Continuous Improvement:

• Stay updated with the latest industry trends and best practices in business intelligence and data analytics.
• Identify opportunities for process improvement and implement innovative solutions.
• Participate in code reviews and knowledge-sharing sessions within the team.

EEO

Education:

• Bachelor's degree in computer science, information technology, data science, or a related field.

Experience:

• Proven experience as a Reporting Engineer or similar role.
• Hands-on experience with Power BI, including DAX and Power Query.
• Strong knowledge of Azure services, including ADF, Azure SQL DB, MS Fabric and Data Lakes.
• Proficiency in Python for data analysis, automation, and machine learning.

Skills:

• Excellent analytical and problem-solving skills.
• Strong understanding of data warehousing concepts and database design.
• Ability to manage multiple tasks and projects in a fast-paced environment.
• Excellent communication and interpersonal skills.

Certifications (Preferred):

• Microsoft Certified: Data Analyst Associate.
• Microsoft Certified: Azure Data Engineer Associate.
• Relevant Python certifications or coursework.

Work Environment:

• This position may offer a hybrid work model, with the flexibility to work from home and on-site as required.
• Occasional travel might be needed for stakeholder meetings or training sessions.

It will be a plus:

• Knowledge of HIPAA and SOC2
• Azure DevOps and Git experience
• .Net experience and EF (Entity Framework)