analyze and organize raw data from multiple sources to produce requested or required data elements
design table structures and ETL to build performant data solutions that are scalable in a fast-growing data ecosystem
create reconciliation procedures and data checks to ensure data quality
build in automated audit, balancing and controls
lead user requirements gathering and documentation designs
proactively conduct data investigations and assist business partners with complex data analysis and ad-hoc queries
lead application and technical architecture analysis, design and implementation, and ensure BI product fulfills requirements
lead efforts with data management and database specialists to troubleshoot and report issues
design new reporting applications to ensure reporting requests can be supported by the underlying data source
understand configuration dependencies and interrelationships between data warehouse and business intelligence tools and designs; troubleshoot in the area with this knowledge
proactively identify, build and maintain relationships with business process owners
Requirements:
Required:5+ years of Python development experience
5+ years of SQL development experience, especially with SQL Server and DB2
experience translating business and data requirements into technical solutions
excellent leadership, communication, and collaboration skills
mentor other developers on the team.
Preferred:
experience with Python 3.x
working knowledge of data warehousing concepts, data structures, and ETL best practices