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.