Technical Project Lead: Contractor
Kaizen Analytix LLC, an analytics consulting services and product firm that gives clients unmatched speed to value through analytics solutions and actionable business insights, is seeking candidates for a talented Senior Data Engineer to join our team.
As a Technical Project Lead, you will be expected to work independently, schedule meetings with SMEs and Vendors, collect requirements, perform data mapping to warehouse, schedule & coordinate development, hands on prototyping, ad hoc process of data files and transform them into structured data that can be ingested on a production basis. The ideal candidate will have a strong background in managing teams, vendors, data engineering, including experience with SQL Server, ETL processes, data modeling, and cloud platforms.
Responsibilities:
- Work with data SME’s and data architects to create end user friendly data models to support data warehouse setup.
- Works closely with Vendors, customers, and colleagues to identify opportunities to utilize information systems to improve business processes, promote the strategic use of information while enabling seamless access to information.
- Interacts with the staff to produce data mapping and requirements, deliver high quality solutions.
- Provides prototyping solutions, prepares test scripts, and conducts tests and for data replication, extraction, loading, cleansing, and data modeling.
- Possesses strong working knowledge of Relational Database Management Systems (DBMS) and data warehouse front-end tools.
- Be proficient in creating and maintaining data models, objects, processes and stored procedures.
- Works closely with the technical and business team lead to drive solution options analysis, development, and implementation of BI solutions.
- Contributing team member to the design and support of data architecture, database design and integration, transformations, and load processes.
Job Requirements:
- Bachelor’s or master’s degree in computer science, engineering, or a related field.
- 10+ years in Data Engineering – consuming, wrangling, validating, developing pipelines for data.
- Working experience working with Python is a plus.
- 10+ years of Experience working with SQL.
- 5+ years of Experience with managing vendors, engineering/development team
- Familiarity with the basic principles of distributed computing and data modeling.
- Excellent problem-solving and analytical skills, with the ability to troubleshoot complex data issues and optimize data processes.
- Working experience with Dimensional Modeling.
- Strong experience with Snowflake and SQLServer is a must.
- Strong experience with Azure platform, Azure Data Factory, Azure Synapse is a must.
- Working experience with Typescript/Javascript is a plus.
- WebApp development experience is a plus
- Strong written and verbal communication skills.
- Be open to receiving constructive feedback.
Ability to work in a fast-paced, rapidly growing company and handle a wide variety of challenges, deadlines, and a diverse array of contacts.
Azure Data Factory cloud-platforms azure-synapse Data Engineering dimensional-modeling JavaScript Data Architect Microsoft SQL Server snowflake-cloud-data-platform database-design data-modeling TypeScript Information Systems ETL