Role: Analytics Engineer
Location: Houston, TX 77086
Hybrid: 4 days onsite
Work Authorization: USC or Green Card Holder
Job Description:
- We are seeking a technically strong Analytics Engineer to support the development, transformation, and governance of enterprise data used for business reporting and analytics.
- This position focuses on the critical layer between raw data ingestion and business reporting. The ideal candidate will have strong hands-on SQL development and data modeling experience, combined with the ability to develop and govern Power BI semantic models and administer Microsoft Fabric environments.
- Unlike a traditional Power BI Developer position, this role emphasizes data preparation, transformation, modeling, and governance rather than dashboard visualization.
- Working closely with the Sr. Manager, Data & Analytics and business stakeholders, this individual will help ensure data is accurate, properly structured, secure, and ready for enterprise reporting.
Key Responsibilities
SQL Development & Data Transformation
- Design, develop, and maintain complex SQL views, staging tables, and data models within an Azure SQL data warehouse.
- Transform raw and integrated data into structured, reporting-ready datasets.
- Develop SQL logic for complex business rules, joins, deduplication, reconciliation, and data classification.
- Build and maintain dimensional data models, including fact and dimension tables and star schemas.
- Optimize SQL queries and data transformations for performance, scalability, and accuracy.
- Push transformation and processing logic upstream into SQL where appropriate rather than relying on complex downstream Power BI calculations.
Power BI Semantic Modeling
- Design, develop, maintain, and govern enterprise Power BI semantic models.
- Build and manage table relationships, DAX measures, calculations, and row-level security.
- Review and validate semantic models supporting reporting developed by business teams.
- Troubleshoot data accuracy, model performance, and refresh issues.
- Ensure consistent definitions and application of business metrics across reporting environments.
- Support report development when needed, with primary emphasis on the underlying data and semantic architecture.
Microsoft Fabric Administration & Governance
- Support administration and governance of the Microsoft Fabric environment.
- Manage Power BI/Fabric workspaces, security permissions, access controls, and user roles.
- Support deployment, review, and production-readiness processes for semantic models and reports.
- Establish and maintain standards for data access, security, model development, and reporting governance.
- Assist with ongoing platform improvements as the organization expands its Fabric capabilities.
Data Pipeline Support
- Monitor and troubleshoot existing Azure Data Factory pipelines and scheduled Power BI refreshes.
- Investigate data processing failures, transformation issues, and downstream reporting discrepancies.
- Make modifications to existing pipelines as business requirements evolve.
- Collaborate with internal resources and external data engineering teams to ensure reliable data delivery.
- Support future data transformation initiatives involving Microsoft Fabric and PySpark notebooks.
Business Collaboration & Data Quality
- Partner with Finance, Operations, and other business stakeholders to understand reporting requirements and complex business rules.
- Translate business requirements into accurate SQL transformations and reusable data models.
- Validate data integrity, reconciliation logic, and reporting consistency.
- Maintain documentation for data models, transformations, metric definitions, and data lineage.
- Identify opportunities to improve data quality, standardization, performance, and reporting reliability.
Required Qualifications
- 3+ years of hands-on experience in analytics engineering, SQL development, business intelligence engineering, or data warehouse development.
- Strong SQL development skills , including complex queries, CTEs, window functions, joins, views, and data transformation logic.
- Experience developing and maintaining data warehouse models using dimensional modeling principles, including star schemas and fact/dimension tables.
- Hands-on experience building and managing Power BI semantic models, including relationships, DAX measures, and security configuration.
- Working knowledge of Microsoft Fabric or Power BI environment administration, including workspaces, permissions, access controls, and governance.
- Understanding of ETL/ELT concepts, pipeline orchestration, and data transformation processes.
- Experience troubleshooting data quality, refresh failures, reporting discrepancies, and performance issues.
- Ability to work directly with business stakeholders to translate complex business rules into accurate data models.
Preferred Qualifications
- Experience working with Azure SQL Database or Azure SQL-based data warehouses.
- Experience supporting or modifying Azure Data Factory pipelines.
- Experience with Databricks or comparable ETL/data integration platforms.
- Exposure to Microsoft Fabric Lakehouses, notebooks, and Dataflows Gen2.
- Hands-on experience with Python or PySpark for data transformation.
- Experience with ERP, financial, operational, or other enterprise transactional data.
- Familiarity with Git, source control, and development standards.
About INSPYR Solutions
Technology is our focus and quality is our commitment. As a national expert in delivering flexible technology and talent solutions, we strategically align industry and technical expertise with our clients' business objectives and cultural needs. Our solutions are tailored to each client and include a wide variety of professional services, project, and talent solutions. By always striving for excellence and focusing on the human aspect of our business, we work seamlessly with our talent and clients to match the right solutions to the right opportunities. Learn more about us at inspyrsolutions.com.INSPYR Solutions provides Equal Employment Opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, genetics, or any other protected status. INSPYR Solutions complies with all applicable laws governing nondiscrimination in employment in every location in which the company has facilities. Applicants requiring reasonable accommodation during the application or interview process should contact HR@inspyrsolutions.com for assistance.
Information collected and processed through your application with INSPYR Solutions (including any job applications you choose to submit) is subject to INSPYR Solutions' Privacy Policy and INSPYR Solutions' AI and Automated Employment Decision Tool Policy: https://www.inspyrsolutions.com/policies/. By submitting an application, you are consenting to being contacted by INSPYR Solutions through phone, email, or text.
26-160666