Data Engineer / BI Developer (Principal engineer)

About the Role: We are seeking a dynamic and skilled Data Engineer / Business Intelligence Developer to join our growing team. This role combines the responsibilities of developing data engineering solutions and implementing business intelligence strategies, allowing you to contribute to both data infrastructure and business decision-making. You will lead initiatives involving the design, development, and maintenance of data systems, dashboards, and reports, while collaborating with cross-functional teams to deliver actionable insights and data-driven solutions. Experience with data warehouse design and implementation (Kimball and Inmon methodology). Knowledge of HIPAA constraints and experience handling sensitive PHI data. Hands on Migrating data from one server to another, ensuring seamless transitions and minimal downtime. Transferring data from on-premises servers to cloud environments, preferably Azure. Migrating reports from one Business Intelligence (BI) platform to another, ensuring minimal disruption to business operations. Hands-on experience with implementing Microsoft Fabric accounts.

Key Responsibilities:

Data Engineering:

• Design, develop, and maintain large-scale data warehouses and ETL pipelines using tools such as SSIS, Power Automate, and other relevant technologies.

• Create and implement data models to enhance data accessibility and consistency.

• Develop and enforce data governance policies, ensuring high data quality, security, and compliance across systems.

• Collaborate with cross-functional teams (e.g., product, sales, and business stakeholders) to identify, prioritize, and refine data requirements.

Business Intelligence Development:

• Design, develop, and maintain business intelligence solutions leveraging tools like Power BI and Pyramid Analytics.

• Create effective data visualizations, reports, and dashboards that support business decision-making.

• Proven expertise in writing efficient and effective DAX (Data Analysis Expressions) scripts to meet specific business requirements

• Engage with stakeholders to understand and prioritize reporting needs, translating business requirements into clear, actionable BI solutions.

• Develop and maintain data subscriptions, data alerts, and other BI features to enhance business operations.

Collaboration & Leadership:

• Collaborate closely with cross-functional teams to align data initiatives with business objectives, providing insights to optimize strategies and decision-making.

• Provide technical leadership and mentorship to junior team members, helping them grow their skill sets and navigate complex challenges.

• Actively participate in Agile methodologies, including sprint planning, daily stand-ups, and retrospectives, to ensure successful project delivery.

Qualifications:

• Proven experience in data engineering, ETL pipeline development, and managing data warehouses.

• Strong experience with Power BI, Pyramid Analytics, and other BI tools for designing visualizations and reporting.

• Proficiency in tools like SSIS, Power Automate, and similar technologies for data integration.

• Solid understanding of data modelling, data governance, and data quality management.

• Excellent communication and collaboration skills, with the ability to work with technical and non-technical stakeholders.

• Experience in leading or mentoring teams, with a track record of delivering technical solutions and promoting best practices.

• Familiarity with Agile development methodologies and working in scrum environments is a plus.

Preferred Qualifications:

• Bachelor’s degree in Computer Science, Data Science, Information Systems, or a related field.

• Experience with cloud platforms preferably  Azure.

• Knowledge of SQL, DAX, or other data-related languages.