Highlights
Desirable technologies: Azure Data Factory| Azure Synapse Analytics| Azure Databricks| Microsoft Fabric Data Factory / Data Engineering| OneLake / Lakehouse| Delta Lake| SQL Server / Azure SQL| Snowflake. "Strong stakeholder management and requirements gathering; cross-functional collaboration; analytical problem solving; clear technical/non-technical communication; Agile delivery; attention to data accuracy, security, governance, scalability, and.
Numbers & Facts
| Location | Aurora, IL |
| Industry | Computer/IT Services |
| Salary | $60–$62 Per Hour |
| Company Size | 500 to 999 employees |
| Year Founded | 1990 |
| Website | http://q1tech.com/ |
Description
| Job Description: | Bill Rate: $ 60-62 Location: ONSITE- Phoenix,AZ Duration: 6 month Role Title: Power BI Engineer / Developer Description: "Power BI & Business Intelligence • Design, develop, and maintain enterprise-grade Power BI dashboards, reports, and semantic models. • Build intuitive interactive visualizations that translate complex datasets into actionable business insights. • Develop advanced DAX calculations and business logic; use Power Query / M for transformation, cleansing, and preparation. • Configure and optimize semantic models, RLS, Import/DirectQuery/composite models, incremental refresh, and data gateways. • Establish reusable reporting standards, templates, KPI definitions, and visualization best practices. • Support deployment and lifecycle management across development, testing, and production; troubleshoot report, refresh, gateway, semantic-model, and performance issues. Data Engineering • Design, build, and maintain scalable ETL/ELT pipelines supporting analytics and reporting. • Integrate data from databases, APIs, files, cloud platforms, and enterprise applications. • Develop optimized SQL queries, stored procedures, views, and transformation logic. • Build and maintain data warehouse, data lake, and/or lakehouse solutions. • Implement data cleansing, transformation, validation, reconciliation, and quality-control processes. • Develop reusable pipelines/frameworks using Python, PySpark, SQL, and cloud-native services. • Implement monitoring, error handling, logging, alerting, and operational support for pipelines. • Optimize large datasets and processing workloads for performance, reliability, and cost efficiency. • Support metadata, lineage, governance, data-quality, CI/CD, and version-control practices. Collaboration & Delivery • Partner with business stakeholders, analysts, data engineers, and technology teams to transform complex data into reliable, governed, actionable insights. • Balance business requirements with scalable technical design and document architectures, data models, business rules, and operational processes. • Work effectively in Agile and cross-functional environments and communicate technical concepts to technical and non- technical stakeholders. • Deliver end-to-end analytics products from source ingestion and transformation through semantic modeling and executive- ready Power BI reporting." KEYWORDS "Strong stakeholder management and requirements gathering; cross-functional collaboration; analytical problem solving; clear technical/non-technical communication; Agile delivery; attention to data accuracy, security, governance, scalability, and maintainability." EXPERIENCE_RANGE_IN_REQUIRED_SKILLS 5-8 Years Role Descriptions: Power BI & Business Intelligence Strong hands-on experience with Microsoft Power BI Desktop and Power BI Service. Advanced proficiency in DAX| Power Query / M| SQL| semantic models| relationships| filter context| security| refresh strategies| and performance optimization. Design efficient star/snowflake schemas| dimensional models| reusable semantic layers| and enterprise reporting standards. Implement Row-Level Security (RLS)| data-access controls| Import| DirectQuery| composite models| incremental refresh| and gateways. Experience with Power BI REST APIs| Tabular Editor / DAX Studio| and Microsoft Fabric is highly desirable.Data Engineering & Analytics Design and develop scalable ETL/ELT pipelines and integrate structured/semi-structured data from databases| APIs| files| cloud platforms| and enterprise applications. Strong SQL skills including complex queries| stored procedures| views| transformation logic| and workload optimization. Strong understanding of data warehouses| dimensional modeling| data lakes| and lakehouse architectures. Hands-on experience with Python / PySpark and cloud-native data services. Experience with at least one major cloud data ecosystem| preferably Microsoft Azure. Desirable technologies: Azure Data Factory| Azure Synapse Analytics| Azure Databricks| Microsoft Fabric Data Factory / Data Engineering| OneLake / Lakehouse| Delta Lake| SQL Server / Azure SQL| Snowflake.DevOps| Governance & Quality Git/version control and CI/CD concepts using Azure DevOps / GitHub and deployment pipelines. Data lineage| metadata management| data-quality frameworks| role-based access| and data security. Strong analytical| troubleshooting| stakeholder-management| requirements-gathering| and documentation skills. Ability to diagnose performance bottlenecks across SQL| pipelines| semantic models| and Power BI reports.Roles & ResponsibilitiesPower BI & Business Intelligence Design| develop| and maintain enterprise-grade Power BI dashboards| reports| and semantic models. Build intuitive interactive visualizations that translate complex datasets into actionable business insights. Develop advanced DAX calculations and business logic; use Power Query / M for transformation| cleansing| and preparation. Configure and optimize semantic models| RLS| Import/DirectQuery/composite models| incremental refresh| and data gateways. Establish reusable reporting standards| templates| KPI definitions| and visualization best practices. Support deployment and lifecycle management across development| testing| and production; troubleshoot report| refresh| gateway| semantic-model| and performance issues.Data Engineering Design| build| and maintain scalable ETL/ELT pipelines supporting analytics and reporting. Integrate data from databases| APIs| files| cloud platforms| and enterprise applications. Develop optimized SQL queries| stored procedures| views| and transformation logic. Build and maintain data warehou Essential Skills: Power BI & Business Intelligence Strong hands-on experience with Microsoft Power BI Desktop and Power BI Service. Advanced proficiency in DAX| Power Query / M| SQL| semantic models| relationships| filter context| security| refresh strategies| and performance optimization. Design efficient star/snowflake schemas| dimensional models| reusable semantic layers| and enterprise reporting standards. Implement Row-Level Security (RLS)| data-access controls| Import| DirectQuery| composite models| incremental refresh| and gateways. Experience with Power BI REST APIs| Tabular Editor / DAX Studio| and Microsoft Fabric is highly desirable.Data Engineering & Analytics Design and develop scalable ETL/ELT pipelines and integrate structured/semi-structured data from databases| APIs| files| cloud platforms| and enterprise applications. Strong SQL skills including complex queries| stored procedures| views| transformation logic| and workload optimization. Strong understanding of data warehouses| dimensional modeling| data la |
|---|
About Company
Q1 consists of experienced and recognized experts providing the capability to respond to market demand in order to provide professional services for our clients including Enterprise software implementations, application integration and technical / functional support.
Q1 has steadily grown into a Quality IT services and solutions organization with the average experience of our team being over 10 years. We have continuously met or exceeded client expectations by delivering professional services and project implementations on time and under budget to help clients truly recognize return on investment.
