> Markdown version of [/jobs/ext/547920-bi-data-analyst-ii](https://www.wearedevelopers.com/jobs/ext/547920-bi-data-analyst-ii). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # BI Data Analyst II - **Company:** SCI Shared Resources, LLC - **Location:** Houston, TX, United States - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Business Analytics Applications, Data Analysis, Cloud Computing, Information Systems, Data Cleansing, Information Engineering, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Transformation, Data Mining, Data Profiling, Data Warehousing, Database Schema, Dimensional Modeling, Machine Learning, Microsoft SQL Server, Performance Tuning, Power BI, Azure Machine Learning, SQL Stored Procedures, SQL Databases, Feature Engineering, Sql Optimization, Generative AI, Powerquery, Information Technology, Machine Learning Operations, Tools for Reporting, Azure Synapse Analytics, Data Pipelines - **Published:** June 11, 2026 - **Apply:** https://www.juju.com/job/00000000g7eo45 ## About the Role Bachelor's degree in computer science, Information Systems, Engineering, Business Analytics, Data Science, or a related field. Experience + Five (5) years of Information Technology experience with a strong focus on data integration, data warehousing, business intelligence, and analytics solutions. + Three (3) years of hands-on experience developing and maintaining Azure Synapse Analytics Pipelines. + Experience integrating data from multiple sources, including cloud and on-premises systems. + Three (3) years of experience designing, developing, and supporting Power BI dashboards, reports, and datasets. + Strong experience in data modeling, dimensional modeling, and data transformation techniques. + Experience developing and optimizing SQL queries, stored procedures, database objects, and SQL Server solutions. + Experience implementing data quality, validation, and governance processes. + Experience managing Power BI workspaces, datasets, gateways, row-level security (RLS), and report deployment processes. + Experience collaborating with business users, data analysts, data scientists, and technical teams to deliver reporting, analytics, and AI-driven solutions. + Experience supporting AI/ML initiatives through data engineering, data preparation, and analytics platforms is preferred. KNOWLEDGE, SKILLS & ABILITIES + Strong knowledge of Azure Synapse Analytics, including Pipelines, Data Integration, and Data Warehousing capabilities. + Advanced proficiency in SQL for data extraction, transformation, analysis, and performance tuning. + Strong experience designing and maintaining ETL/ELT solutions. + Proficiency in Power BI, including report development, dashboard creation, DAX, Power Query, and data modeling. + Experience developing interactive visualizations and executive-level reporting solutions. + Understanding of dimensional modeling concepts, including star and snowflake schemas. + Knowledge of data warehousing principles and best practices. + Understanding of Artificial Intelligence (AI), Machine Learning (ML), Generative AI, and advanced analytics concepts. + Experience supporting AI/ML data pipelines, feature engineering, model deployment processes, and AI-enabled reporting solutions. + Knowledge of Azure AI services, cloud analytics platforms, and modern data architecture patterns is desirable. + Strong analytical and problem-solving skills with the ability to translate business requirements into technical solutions. + Strong communication and collaboration skills for working with business stakeholders and technical teams. + Ability to manage multiple priorities and deliver high-quality solutions in a fast-paced environment. ## Description + Build and manage end-to-end ETL/ELT workflows for ingesting, transforming, and loading data from multiple sources. + Design, develop, and maintain scalable data integration and transformation solutions using Azure Synapse Analytics Pipelines. + Develop, optimize, and monitor data pipelines to ensure data quality, reliability, and performance. + Create and maintain data models, datasets, and reporting solutions using Power BI. + Design interactive dashboards, reports, and visualizations to support business intelligence and decision-making. + Manage data refresh schedules, report deployments, and security configurations within Power BI. + Collaborate with business stakeholders to gather reporting and analytics requirements. + Develop and implement dimensional data models, including star and snowflake schemas, to support data warehousing and business intelligence initiatives. + Perform data analysis and data profiling to identify data quality issues and improve data integrity across systems. + Leverage Artificial Intelligence (AI) and Machine Learning (ML) technologies to support advanced analytics, predictive modeling, and business insights. + Collaborate with data scientists, business analysts, and stakeholders to integrate AI-driven solutions into enterprise reporting and decision-making processes. + Evaluate emerging AI, Generative AI, and cloud-based analytics technologies to identify opportunities for innovation and process improvement. + Implement AI-powered data quality, anomaly detection, forecasting, and automation solutions to enhance business operations and reporting capabilities. ## Related Videos - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) - [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data) - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Inside the AI Revolution: How Microsoft is Empowering the World to Achieve More](https://www.wearedevelopers.com/videos/869-inside-the-ai-revolution-how-microsoft-is-empowering-the-world-to-achieve-more) - [Data Mining Accessibility](https://www.wearedevelopers.com/videos/802-data-mining-accessibility) ## Related Articles - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [What Industries Outside of AI Are Hiring The Most AI Experts?](https://www.wearedevelopers.com/magazine/98-what-industries-outside-of-ai-are-hiring-the-most-ai-experts) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)