"Alerted.org

Data Analyst 16295 * Hourly pay: $45-$55/hr * Worksite: Leading professional development and networking company (Omaha, NE 68144 - Hybrid, Must be onsite on Tuesdays, Wednesdays, and Thursdays) * W2 Employment, Group Medical, Dental, Vision, Life, Retirement Savings Program, PSL * 40 hours/week, 12 Month Assignment A leading professional networking company seeks a Data Analyst. The successful candidate will robust data solutions that support critical business operations, and focus on developing tables, views, and stored procedures; creating and maintaining Power BI reports; and building pipelines and automations in Azure Data Factory. The company offers a great work environment! Data Analyst 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. Data Analyst Qualifications: * 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 a strong understanding of operational processes and data needs. * BS/MS in a quantitative field (Statistics, Data Science, Mathematics, Economics, Computer Science, or related), or equivalent practical experience. * 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. * Exposure to Power Automate for workflow automation is preferred. * Familiarity with data lake platforms (e.g., Hadoop) and orchestration tools like Apache Airflow is preferred. * Experience with big data technologies (e.g., Spark) and scripting languages (Python, R) is preferred. * Knowledge of workforce planning, scenario analysis, and optimization techniques is preferred. * Strong communication skills to present findings to both technical and non-technical audiences are preferred.