Job description
Responsible for writing and maintaining the Atlas SQL codebase and its data integrations. They take the requirements from the data team and transform them into datasets that can be used in Power BI reports, Azure datasets, or ad-hoc analysis. They may need to do research on definitions and data structures. Works with the data team to produce datasets that drive essential business functions.
Note: 100% of job duties performed at an approved remote work location.
5 years of experience with complex SQL, including performance tuning, window functions, views, stored procedures
1 year of experience with Agile software development
Strong communication and documentation skills
Ability to work remotely 100% of the time in a secure working environment
PREFERRED QUALIFICATIONS
Bachelor’s Degree in computer science, Data Analytics, etc. is preferred. Strong working knowledge and experience with Snowflake, Fivetran, and DBT, data design experience in Microsoft Azure. Must be extremely adept at SQL, including performance tuning, window functions, views, and stored procedures. Must be able to write queries without a complete data dictionary, making inferences, and testing hypotheses about data and its structures with little direct supervision.
Note: 100% of job duties performed at an approved remote work location.
Job Responsibilities
ESSENTIAL FUNCTIONS- Assembling large, complex sets of data that meet non-functional and functional business requirements
- Identifying, designing and implementing internal process improvements, including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes
- Building required infrastructure for optimal extraction, transformation, and loading of data from various data sources using Fivetran, Snowflake, and DBT technologies
- Building analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics including operational efficiency and customer acquisition
- Working with stakeholders including data, design, product and executive teams and assisting them with data-related technical issues
- Working with stakeholders including the executive and data teams to support their data infrastructure needs while assisting with data-related technical issues
- Integrating new data sources into Snowflake using Fivetran, both with prebuilt connectors and by writing in-house connectors
- Making connections between disparate datasets
- Work extensively with Data Analyst to create Power BI reports from datasets
- Understand underlying business concepts and implement logic in datasets/view
- This is a remote role and employee is a self-motivated, high performer who thrives in an independent work environment, and is not needed onsite for projects or team activities.
Required Skills and Qualifications
MINIMUM QUALIFICATIONS5 years of experience with complex SQL, including performance tuning, window functions, views, stored procedures
1 year of experience with Agile software development
Strong communication and documentation skills
Ability to work remotely 100% of the time in a secure working environment
PREFERRED QUALIFICATIONS
Bachelor’s Degree in computer science, Data Analytics, etc. is preferred. Strong working knowledge and experience with Snowflake, Fivetran, and DBT, data design experience in Microsoft Azure. Must be extremely adept at SQL, including performance tuning, window functions, views, and stored procedures. Must be able to write queries without a complete data dictionary, making inferences, and testing hypotheses about data and its structures with little direct supervision.
jjbodyshop.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, jjbodyshop.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, jjbodyshop.com is the ideal place to find your next job.