Metropolitan Airports Commission
Data Engineer
MN, US | $97K - $151K
Qualifications
- Senior Level Individual Contributor (SRIC) Competencies
- Customer Focus - Building strong customer relationships and delivering customer-centric solutions
- Manages Complexity - Making sense of complex, high quantity, and sometimes contradictory information to effectively solve problems
- Decision Quality - Making good and timely decisions that keep the organization moving forward
- Resourcefulness - Securing and deploying resources effectively and efficiently
- Values Differences - Recognizing the value that different perspectives and cultures bring to an organization
- Communicates Effectively - Developing and delivering multi-mode communications that convey a clear understanding of unique needs of different audiences
- Persuades - Using compelling arguments to gain the support and commitment of others
- Courage - Stepping up to address difficult issues, saying what needs to be said
- Instills Trust - Gaining the confidence and trust of others through honesty, integrity and authenticity
- Being Resilient - Rebounding from setbacks and adversity when facing difficult situations
- Bachelor’s degree in computer science or technology related field or equivalent four or more years of professional experience in data development
- Four or more years of experience in ETL processes, and data integration
- Strong knowledge of database technologies (e.g., SQL, NoSQL, distributed databases)
- Four or more years of experience writing complex SQL queries, stored procedures, and functions
- Hands-on experience building data pipelines with Azure Data Factory Studio or Azure Synapse Analytics
- Knowledge in data warehousing and data lake design
- Experience with data reporting tools (e.g., Power BI, Qlik, Tableau, Crystal Reports)
- Experience in a development support role of enterprise systems and applications
- Experience with full project life cycle: Requirement analysis, design, development, test and support
- Strong problem-solving and communication skills
- Possession of a valid, state issued driver’s license
- Experience with Azure DevOps, and CI/CD pipeline
- Experience developing software using Agile methodologies
Responsibilities
- This is an excellent opportunity to play an important role in delivering innovative technology to the passengers of MSP Airport
- This role is responsible for the ongoing support of data analytics and the MAC’s data analytics platform
- Willing to work in a team environment, working closely with architects, business analysts, and project managers to understand business requirements
- Lead effort to profile, clean, transform, and catalog data assets using Microsoft Intelligent Data Platform / Microsoft Fabric and Microsoft Power Platform
- Lead development of ETL processes to land, enrich, and curate data from various sources in collaboration with data architect
- Work with the pertinent stakeholders to identify appropriate and necessary data and reporting requirements and turn raw data into relevant and meaningful insights
- Collaborate with data analysts to manage Power BI assets, including reports, dashboards, workspaces, and the underlying authoritative data sets
- Team up with data architect to Implement and configure proper security procedures, in conjunction with stakeholder requirements, to ensure the safekeeping of all data assets
- Work together with data architect to determine and locate appropriate data sources that meet stakeholder requirements
- Assist data architect in ensuring proper access to the needed data sources
- Work with data architect to identify new processes or improve existing processes
- Design and build scalable and effective authoritative data sets to enable and implement advanced analytics capabilities
- Contribute to the continuous improvement of development practices, design and documentation
- Maintain technical knowledge of changing application development landscape and business trends
- Support applications in a Microsoft environment including scheduled maintenance, enhancements, and troubleshooting break/fix scenarios
- These duties may require action outside of normal business hours and possibly on weekends or holidays
- Troubleshoot and resolve performance bottlenecks
- 501-1,000 employees
- Transportation, Aviation, Government, Transportation and Logistics, Travel and Tourism, Airports, Infrastructure, Government and Public Sector
- Government Agency
- Minneapolis, MN
Company information
The Metropolitan Airports Commission (MAC) is dedicated to providing services that consistently exceed the expectations of its customers. Whether it's providing exciting shopping and healthy dining options at Minneapolis-St. Paul International Airport (MSP), plowing snow from one of its seven airports' runways, designing and building sustainable facilities, or ensuring the organization's long-term financial strength, the MAC strives to fulfill its vision statement: Providing your best airport experience. Created in 1943 by Minnesota state law, the MAC is a public corporation providing coordinated aviation services throughout the Twin Cities metropolitan area. In fact, the MAC operates one of the largest airport systems in the nation, which includes MSP and six general aviation airports. Together these airports help drive the region's economy and job growth while providing quick, easy access to destinations around the globe. A 15-member board of commissioners appointed by Minnesota's governor and the mayors of Minneapolis and Saint Paul establishes the commission's policies. Those policies are implemented by the commission's senior leadership and staff. The MAC and its airports are funded through rents and fees paid by airport users, not by general tax dollars.
