"Alerted.org

Job Description

We are looking for a highly experienced Senior Data Engineer responsible for developing advanced analytics and predictive models, including machine learning solutions, to support data-driven decision-making. This role leads the integration of data mining techniques into business processes and manages the use of specific database platforms to ensure efficient data utilization. The Technical Lead identifies opportunities to apply industry best practices, enhance system performance, and deliver innovative solutions that improve client outcomes. This role requires deep expertise in data engineering, strong SQL skills, and a solid understanding of Power BI data modeling to ensure reliable, scalable, and high-performance reporting solutions.

Key Responsibilities:

• Translate business needs into functional specifications, wireframes, and data models.

• Conduct gap analysis and identify opportunities for process improvement through data insights.

• Facilitate communication between business users and technical teams to ensure alignment.

• Lead user acceptance testing (UAT) and ensure dashboard accuracy and usability.

• Maintain documentation including business process flows, data dictionaries, and user guides.

• Design, develop, and maintain Power BI dashboards and reports based on business requirements.

• Create and optimize data models using Power BI Desktop and DAX.

• Integrate data from multiple sources including SQL databases, Excel, and cloud platforms.

• Ensure performance tuning, data accuracy, and visual consistency across dashboards.

• Stay current with Power BI updates and recommend new features or improvements.

• Design and build robust, scalable data pipelines to support Power BI dashboards.

• Collaborate with BI developers and business stakeholders to understand data requirements.

• Develop and maintain ETL processes using tools such as Azure Data Factory or custom scripts.

• Optimize data models and queries for performance and scalability in Power BI.

• Monitor and troubleshoot data pipeline issues and dashboard performance.

• Document data architecture, processes, and standards.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [email protected] learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

Skills and Requirements

Required Qualifications:

• Experience in data engineering or related roles.

• Strong proficiency in SQL and experience with relational databases (e.g., SQL Server, PostgreSQL).

• Hands-on experience with Power BI, including data modeling and DAX.

• Proficiency in ETL tools and scripting languages Python

• Solid understanding of data warehousing concepts and dimensional modeling.

• Excellent problem-solving and communication skills.

Preferred Qualifications:

• Industry experience in finance, utilities

• Understand agile methodology concepts

• Experience with data pipelines and DevOps practices for data workflows.

• Knowledge of data governance frameworks and compliance standards.