BI Engineer

Location: 6000 N. Terminal Pkwy, Atlanta, Georgia 30320 | Duration: 4+ months (possibility of extension) | Schedule: 08:00 AM to 05:00 PM (hybrid)

About the role

The Data BI Engineer will lead efforts in researching, designing, and implementing data-driven solutions for the Department of Aviation (DOA). This role focuses on creating visually compelling and actionable insights through Power BI and leveraging the Microsoft Power Platform suite to streamline processes, improve efficiency, and enable informed decision-making across the organization. The engineer will work collaboratively with Airport Information Systems (AIS) and DOA stakeholders to define and deploy Analytics, Data Reporting, and Dashboarding solutions, fostering a culture of operational excellence and data storytelling. The role includes contributing to all phases of Data Business Intelligence projects, from requirements gathering and design to testing and deployment.

Responsibilities

• Research, design, and implement innovative BI and Power Platform solutions, ensuring alignment with organizational goals and priorities.
• Collaborate with stakeholders to define BI and Power Platform project requirements, metrics, and success criteria.
• Create, maintain, and optimize visually compelling Power BI dashboards, reports, and data models.
• Develop solutions using the Microsoft Power Platform suite, including Power Apps, Power Automate, and Power BI, to automate workflows, build custom applications, and enhance data analysis capabilities.
• Partner with business teams to define analytics requirements and deliver actionable insights.
• Implement data transformation processes, design robust data pipelines, and integrate Power Platform tools to support reporting and operational needs.
• Conduct advanced data analysis, predictive modeling, and statistical techniques to derive actionable insights.
• Analyze, manipulate, and process large datasets using Power Query and other appropriate tools.
• Identify unique opportunities to collect, mine, and analyze data to drive operational improvements.
• Build custom applications using Power Apps to address specific operational needs, ensuring seamless integration with other systems.
• Automate and streamline workflows using Power Automate to improve efficiency and reduce manual processes.
• Integrate Power BI with other Microsoft tools and services (e.g., SharePoint, Teams, Dynamics 365) to enhance collaboration and reporting.
• Maintain comprehensive documentation, including data model schemas, architecture diagrams, Power Platform workflows, reporting specifications, and data flow documentation.
• Ensure compliance with established data standards, governance principles, and architecture guidelines.
• Foster a data-driven culture by promoting the use of BI tools, Power Platform solutions, and storytelling to share insights.
• Train and mentor stakeholders on Power BI and Power Platform capabilities, including data visualization and workflow automation best practices.
• Stay current with emerging technologies, Power Platform best practices, and industry trends to enhance the DOA’s analytical and operational capabilities.
• Recommend and implement data-driven solutions that improve budgeting, staffing, marketing, and other operational decisions.
• Collaborate with AIS and other teams to ensure data availability, quality, and consistency.
• Contribute to all phases of BI and Power Platform project lifecycles, including testing, validation, and deployment.
• Drive innovation by exploring new uses for existing data and developing new processes or solutions using the Power Platform suite.
• Perform additional duties as assigned to support departmental goals and objectives.

Requirements

• Bachelor’s degree in Data Science, Computer Science, Statistics, Mathematics, Engineering, or a related field. Equivalent work experience can be substituted for educational requirements.
• Three years of experience in data analysis and visualization.
• Proven track record of implementing BI solutions in large, complex organizations.
• Proficiency in Microsoft Power BI and Tableau.
• Strong grasp of BI methodologies and implementation techniques.
• Familiarity with data modeling, visualization, and reporting best practices.
• Ability to identify and solve complex data problems.
• Expertise in transforming raw data into actionable insights.
• Experience with the Microsoft Power Platform suite (Power Apps, Power Automate, Power BI).

Skills

• Technical Expertise: Advanced skills in Power BI, Power Platform, data modeling, and visualization.
• Analytical Skills: Ability to analyze large datasets, conduct predictive modeling, and derive actionable insights.
• Collaboration and Communication: Ability to build partnerships across internal and external stakeholders. Strong communication and presentation skills to convey technical concepts to non-technical audiences.
• Project Management: Experience in managing end-to-end BI projects. Ability to prioritize and manage multiple tasks effectively.