Job Description & How to Apply Below
Position: Applications Developer 2 - Data Developer
WHO WE ARE
We are the Metropolitan Council, the regional government for the seven-county Twin Cities metropolitan area. We plan 30 years ahead for the future of the metropolitan area and provide regional transportation, wastewater, and housing services.
We are committed to supporting a diverse workforce that reflects the communities we serve.
Information Services is the central IT department supporting all divisions of the Metropolitan Council. Our 140 team members provide technology, practices, and innovative solutions that enable the core services of the Council.
How your work would contribute to our organization and the Twin Cities region:
The Applications Developer 2 – Data Developer will collaborate and work across multiple divisions within the Metropolitan Council: Regional Administration, Metro Transit, Metropolitan Transportation Services, Environmental Services and Community Development. This individual will work in software development, specifically with databases, to make appropriate data accessible and available to data consumers, including data scientists, data and business analysts, citizen integrators and line-of-business users.
They will collaborate across and support business and information services, building, managing, and operationalizing datasets and data pipelines in support of key data and analytics use cases. This individual will also integrate analytics and data science outputs into existing business processes and applications.
They will comply with data governance and data security requirements. This individual will work with domain experts, data scientists and analysts in framing the business problem and provisioning integrated data quickly across multiple environments to help solve the business need.
Best qualified candidates will demonstrate an inherent drive to collaborate and be a self-starter. They will have the ability to be strategic and innovative, and present well thought-out solutions.
Starting Salary Range: $67,683 - $80,000
Full SalaryRange: $67,683 - $102,128
What you would do in this job
Determine stakeholder requirements for data development.
Design and develop efficient data solutions and databases.
Data modeling and database normalization.
Develop and enforce data integrity and referential integrity.
Perform software development using various development methodologies.
Create data solutions for data analysis, data warehousing, reporting, and analytics.
Build and manage reports for data validation.
Conduct capacity planning, feasibility studies, and analyze requirements.
Troubleshoot database connectivity issues, network and application logic problems.
Help perform the installation of data solutions in non-production environments.
Build data integrations, ETL workflows and data pipelines between systems.
May interact with application integrations such as APIs and Web Services.
Help develop and maintain data standards and documentation.
Help create best practices and procedures for managing data.
Help manage database security and setup development and test environments.
Innovate and leverage emerging technology and participate in strategic planning.
Provide consulting services to business units within the Council.
What education and experience are required for this job (minimum qualifications)
A master’s degree in Computer Science, Information Systems or a related field AND one or more years of experience in the areas below
ORA bachelor's degree in Computer Science, Information Systems, or a related field AND
three or more years of experience in the areas belowORAn associate degree in Computer Science, Information Systems, or a related field AND
five years of experience in the areas below
Working with stakeholders to understand business needs and gather business requirements and technology teams to develop data solutions
Database design and data modeling
Building transactional databases, data marts and data warehouses
Creating data integrations and building data pipelines between systems such as using ETL or other data movement tools
Designing and building reports and data visualizations
Working with SQL Server, Oracle and/or other similar database technologies
What additional skills and experience would be helpful in this job (desired qualifications):
Experience with Application Integrations, APIs, Web Services, and Integration Platform as a Service (IPaaS)
Experience developing data solutions for the cloud
BI Tools (i.e. report tools, data integrations) administration experience
What knowledge, skills and abilities you should have:
Ability to retrieve, analyze, and communicate relational and non-relational data
Skills working with XML, JSON, or other semi-structured formats
Knowledge of Windows, Linux and/or Unix OS and related software
General systems management and networking skills
Strong written and verbal communication skills
Self-starter with the ability to work both independently and with a team
What you can expect from us:
We offer the opportunity to make a difference and positively influence the Twin Cities metropolitan area.
We encourage our employees to develop their skills through on-site training and tuition reimbursement.
We provide a competitive salary, excellent benefits and a good work/life balance.
Search for further Jobs Here: