Role : Data Analyst
Location : Omaha, NE 68144 (Hybrid - Tues / Wed / Thurs)
Duration : 12 Months
Job Overview :
We are seeking a Data Analyst with deep expertise in SQL Server to design, build, and maintain robust data solutions that support critical business operations. This role focuses on developing tables, views, and stored procedures; creating and maintaining Power BI reports; and building pipelines and automations in Azure Data Factory. The ideal candidate will combine strong technical skills with analytical thinking to deliver scalable, data?driven solutions.
Key Responsibilities :
- Design, develop, and maintain SQL Server objects including tables, views, stored procedures, and functions.
- Optimize queries and ensure database performance, integrity, and security.
- Build and maintain Power BI dashboards and reports to support evolving business needs.
- Develop and manage data pipelines and workflows in Azure Data Factory for efficient data movement and transformation.
- Collaborate with stakeholders to gather requirements and translate them into actionable data solutions.
- Monitor and troubleshoot data processes, ensuring reliability and accuracy across systems.
- Partner with cross functional teams on strategic projects and operational initiatives.
Basic Qualifications :
BS / MS in a quantitative field (Statistics, Data Science, Mathematics, Economics, Computer Science, or related), or equivalent practical experience.6+ years of experience with SQL (MS SQL Server, Teradata, Oracle, MySQL), with a preference for Microsoft SQL Server (T-SQL) including stored procedures, views, functions, indexing, and query optimization.2+ years of experience with data integration platforms (Azure Data Factory, SSIS, Boomi, etc.), with a preference for Azure Data Factory (pipelines, datasets, data flows).2+ years of experience building and maintaining Power BI dashboards / reports (data modeling, DAX / Power Query, refresh strategies, governance).2+ years of experience working in or supporting operations based workforce teams, with strong understanding of operational processes and data needs.Experience using Git for version control, including common workflows such as branching, committing, pushing, and submitting pull requests for code review and merge.Strong analytical / problem?solving skills and the ability to communicate insights clearly to both technical and non?technical audiences.Preferred Qualifications :
Exposure to Power Automate for workflow automation.Familiarity with data lake platforms (e.g., Hadoop) and orchestration tools like Apache Airflow.Experience with big data technologies (e.g., Spark) and scripting languages (Python, R).Knowledge of workforce planning, scenario analysis, and optimization techniques.Strong communication skills to present findings to both technical and non?technical audiences.Key Metrics for Success :
Accuracy and efficiency of SQL based solutions and data pipelines.Adoption and impact of Power BI reports dashboards across business units.Operational improvements driven by automation and data-driven insights.