Lead-level Power BI specialist designing and delivering semantic models and reports with focus on performance and cost optimisation.
Responsibilities
Design, build and maintain Power BI semantic models and reports to a high technical standard
Develop robust data models in Power BI using DAX and Power Query (M)
Optimise model and report performance through aggregations, incremental refresh, composite models, query folding, relationship design and storage-mode choices
Optimise Power BI or Fabric capacity usage and cost
Connect Power BI to Databricks as a data source
Requirements
A degree in Computer Science, Information Systems, Engineering, Mathematics or a related field, or equivalent practical experience
Senior ETL / Informatica IDMC Engineer with 7+ years of experience in data integration and ETL development, responsible for designing, developing, testing, and maintaining ETL/data integration solutions using Informatica IDMC, Teradata, SQL, and basic Python scripts in a banking/data environment.
Compensation
Salary Range: $35.00 - $37.00/Hour on W2 (Without Benefits).
Responsibilities
Design, develop, test, and maintain ETL/data integration solutions using Informatica IDMC
Develop and maintain mappings, mapplets, workflows, and data integration processes
Work extensively with Teradata for data extraction, transformation, loading, and validation
Write and optimize SQL queries for data analysis, reconciliation, and troubleshooting
Perform data validation, reconciliation, and root-cause analysis for ETL/data quality issues
Requirements
Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field, or equivalent professional experience
Nice to have: knowledge of banking data, transactions, accounts, customers, payments, or regulatory data
Nice to have: experience with data warehouse and enterprise data platforms
Nice to have: experience with ETL production support and incident management
Nice to have: knowledge of cloud-based data integration and modern data platforms
Technical Product Operations Specialist IVLinda Werner & Associates · NYC+3 more