Data Engineer

Description

The Azure Data Engineer, in collaboration with the Business Analyst, business partners, and other technical staff, delivers insightful technology solutions and business reporting, via design, capture, and use of data across systems that support business functions.

Essential Job Functions

• Assess data capture requirement, develop data structure, and develop reports and analysis on medium to high complexity projects

• Provide leadership in the management and design of the reporting environment, including data sources, security, and metadata

• Implement effective business analytics practices, reporting, and analytics that drive improved decision making, efficiency, and performance across the business

• Communicate regularly with technical, business, applications, and operational staff to ensure database integrity, data quality, data reconciliation, data security, and optimized performance

• Support the data warehouse in identifying and revising reporting requirements

• Lead initiatives for data integrity and normalization

• Define data acquisition and development of data set processes using programming language and ETL tools and processes, advanced reporting, and creation of visualizations

• Prepare data for predictive and prescriptive modeling, find hidden patterns using data, and use data to discover tasks that can be automated

• Perform technical troubleshooting, code debugging, and problem solving for custom built data warehousing solutions

• Evaluate changes and updates to source production systems

• Assess tests and implementation of new or updated software, and assist with strategic decisions on new systems

This will be a hybrid position with 3 days a week onsite in the Memphis area.

Salary range is $110-130k.

Additional Skills & Qualifications

• Engineer specific skills:

o Experience managing ODBC connections, SQL jobs, stored procedures, and views

o SQL Clustering & HA

o Scripting SQL Monitoring, alerting, and diagnosis

• Proficient in PostgreSQL or EnterpriseDB database environments

• Proficient in MS SQL Server, Integration Services and/or other Reporting Services

• Formal training on Agile roles, principles, and methodologies

• Experience in an Agile environment

• DAX (Data Analysis Expressions) Knowledge / Proficiency

• Experienced in use MS Office tools, specifically Power BI