Data Engineer / BI & ETL Developer

Core Responsibilities:

• Design, develop, test, deploy, and maintain robust ETL/ELT pipelines that ingest and transform structured and unstructured data from multiple internal and external sources.

• Build, enhance, and optimize data warehouses, data lakes, data marts, and analytical data models using dimensional modeling and appropriate architecture patterns.

• Develop and maintain BI dashboards, reports, semantic models, KPIs, and visualizations that support operational monitoring, management reporting, and strategic analysis.

• Write, review, and optimize complex SQL queries, stored procedures, data transformations, and database objects to achieve reliable and efficient processing.

• Implement automated data validation, reconciliation, quality checks, exception handling, logging, monitoring, and alerting across data workflows.

• Ensure data accuracy, completeness, consistency, lineage, security, performance, availability, and scalability in accordance with organizational standards.

• Monitor, troubleshoot, tune, and resolve failures or performance bottlenecks in pipelines, databases, data models, reports, and BI platforms.

• Work with business stakeholders to elicit, analyze, document, and translate reporting and analytics requirements into practical technical solutions.

• Collaborate with data architects, database administrators, analysts, application teams, information-security teams, and vendors to integrate and deliver data products.

• Apply source control, release management, CI/CD, testing, documentation, and change-management practices to data engineering and BI deliverables.

• Prepare and maintain technical documentation, including source-to-target mappings, data dictionaries, architecture diagrams, operating procedures, and support guides.

• Support data governance, metadata management, access control, privacy, retention, audit, and compliance requirements.

Experience:

• Minimum 5 years of relevant professional experience in data engineering, BI development, ELT/ETL development, analytics engineering, or a closely related role.

• At least 3 years of hands-on experience designing and supporting production ETL/ELT pipelines and analytical data models.

• At least 3 years of hands-on experience developing enterprise BI dashboards and reports using Power BI or an equivalent platform.

• Demonstrated experience with advanced SQL, query optimization, data warehousing, dimensional modeling, and integration of multiple data sources.

• Practical experience implementing data-quality controls, monitoring, troubleshooting, performance tuning, and production support.

• Experience working directly with business stakeholders to define KPIs, reporting requirements, acceptance criteria, and data solutions.

• Experience with Microsoft Azure data services and the Microsoft BI ecosystem is strongly preferred.

• Experience in government or another regulated environment, including data governance and information-security requirements, is preferred.

Technical Competencies:

• Advanced SQL and relational database development.

• ETL/ELT design, orchestration, scheduling, dependency management, and error handling.

• Data warehousing, data lakes, data marts, dimensional modeling, and semantic modeling.

• Power BI development, including data modeling, DAX, Power Query, dashboard design, row-level security, and performance optimization.

• Microsoft data technologies such as Azure Data Factory, Azure Synapse Analytics, Microsoft Fabric, SQL Server, or equivalent platforms.

• Working knowledge of Python or another data-processing language.

• Source control and deployment practices using Git and CI/CD tooling.

Education:

• Bachelor’s degree in Computer Science, Data Engineering, Information Systems, Software Engineering, Computer Engineering, Business Intelligence, Data Analytics, or a closely related discipline.