BI Data Analyst II

SCI Shared Resources, LLC

Houston, TX

Apply

JOB DETAILS

SKILLS

Analysis Skills, Artificial Intelligence (AI), Automation, Best Practices, Business Analysis, Business Intelligence, Business Model, Business Operations, Business Skills, Business Support, Cloud Computing, Communication Skills, Computer Science, Data Analysis, Data Management, Data Modeling, Data Profiling, Data Quality, Data Science, Data Sets, Data Warehousing, Database Extract Transform and Load (ETL), Dimensional Modeling, Forecasting, Identify Issues, Information Technology & Information Systems, Internet Search, Machine Learning, Microsoft SQL Server, Microsoft Windows Azure, Multitasking, Performance Tuning/Optimization, Power BI, Power Management, Predictive Modeling, Problem Solving Skills, Process Improvement, Process Modeling, Query Optimization, Reporting Dashboards, Reporting Skills, Requirements Management, SQL (Structured Query Language), Scalable System Development, Schedule Development, Snowflake Schema, Star Schema, Stored Procedures, Systems Engineering, Team Player, Technical Delivery, Technical Support, Training Data Sets

LOCATION

Houston, TX

POSTED

6 days ago

Our associates celebrate lives. We celebrate our associates. **JOB RESPONSIBILITIES** + 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. **MINIMUM REQUIREMENTS** **Education** 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. Postal Code: 77019 Category (Portal Searching): Information Technology Job Location: US-TX - Houston Job Profile ID: C00175 Time Type: Full time Location Name: SCI Corporate Office II

About the Company

SCI Shared Resources, LLC

Resume Resources

Free Resume Templates Free Resume Builder