Lead Data & Analytics Engineer at SecturaSOFT (Birmingham, AL or Remote)
Secturasoft is a start up with a mission to pioneer commercial software solutions that transform the metal service industry. Join this dynamic team at an early stage and be part of the exciting journey to make a difference to the industry.
Lead Data & Analytics Engineer
As lead data and analytics lead engineer at Secturasoft, you will work with the engineers, product owners, and the business to develop data pipelines, data warehouse, and infrastructure to handle transactional ecommerce products data for effective data analytics for internal and external stakeholders. We are looking for you to lay a strong foundation for our database systems from data point of view and help build data infrastructure to facilitate advanced analytics to support the rapid product and business growth.
Primary job responsibilities:
Work with software development and infrastructure teams to implement and maintain analytics data infrastructure in the cloud ensuring data is secure in transit and at rest
Evaluate and implement appropriate PaaS or SaaS technologies in the cloud to meet the current and future needs of internal and external stakeholders of our software and ecommerce products
Evaluate and implement data pipelines to capture data and ETL/ELT to cloud storage infrastructure
Be a technical data consultant to software development team in the design and development of complex database systems to support current and future business analytics needs
Be on the look out to catch data integrity issues in the design, implementation, and storage of databases
Develop data models and business analytics using analytics tools such as PowerBI including ad-hoc SQL querying to meet the needs of internal stakeholders. This team will grow to include exclusive business anal
Develop technical documentation, data integrity testing infrastructure and support mechanism
Required Skills:
Experience designing and developing ETL/ELT tools in the cloud for the cloud based multi-tenant complex software applications
Familiarity with the Azure data platform including data lakes storage, Azure data factory and Synapse
Familiarity with extracting data from software applications using common API structures such as REST
Working knowledge of Microsoft BI stack (SSAS, SQL server, SSDT, PowerBI, etc)
Proficiency creating tables, views, and stored procedures using T-SQL and PL/SQL including expertise in understanding query performance
Experience designing and maintaining Datawarehouse in Azure or other next gen products like Snowflake
Experience with data analytics, visualization and reporting
Understanding of Python for data engineering
Powershell experience
Communicate effectively with the technical, business, and other stakeholders to deliver and meet their data and analytics needs.
Education: Bachelor’s or master’s degree in computer science or a related discipline and 5+ years of relevant experience