Senior Data Architect

About the Position:

Reporting to the Director of Technology, this Data Architect will work on the collecting, storing, processing, and analyzing of sets of data. The Data Architect must also have exceptional analytical skills, showing fluency in the use of tools such as Python, Shell, Java, PHP, and T-SQL programming skills. The candidate must additionally be capable of developing databases using SSIS packages, T-SQL, MSSQL, and MySQL scripts.

The candidate will also have an ability to design, build, and maintain the business's ETL pipeline and data warehouse. The candidate will also demonstrate expertise in data modeling and query performance tuning on SQL Server, MySQL, Redshift, Postgres or similar platforms.

Responsibilities:

• Develop complex tabular models and cubes
• Employ a variety of languages and tools to query databases, create scripts, and marry systems together
• Assemble large and complex data sets to meet business requirements
• Collect, clean, mine, analyze, and interpret data
• Create Proof of Concepts
• Utilize advanced statistical techniques to manipulate data and draw insights
• Assess the effectiveness and accuracy of new data sources and data gathering techniques
• Develop processes and tools to monitor and analyze model performance and data accuracy
• Bring data into the Data Lake
• Enable clients to bring data-driven insights into their business decisions through enterprise reporting dashboards and KPIs
• Collaborate with cross-functional teams to deliver analytics solutions
• Empower users to bring data to life through self-service models and Business Intelligence Analytics tools
• Develop custom predictive models and algorithms using AI and Machine Learning

Qualifications:

• Bachelors Degree (preferred)
• 3+ years of demonstrated data engineering experience or development experience
• 3+ years of experience with Big Data Technologies like Hadoop or Hive
• 3+ years experience in custom ETL design, implementation and maintenance
• Proficient designing and implementing data models and data integration
• Experienced deploying Azure SQL Database, Azure Data Factory and well-acquainted with other Azure services including Azure Data Lake and Azure ML
• Experience implementing REST API calls and authentication
• Experienced working with agile project management methodologies
• 2 years ETL experience (preferred)
• 3 years Software Development experience (preferred)
• 1 year Data Integration experience (preferred)

Preferred Qualifications

• Spark Programming (Azure Databricks preferable)
• Python, Java & SQL
• Knowledge of Azure Cloud (Data Platform Technologies)
• Manage high volume, high traffic GDPR solutions build
• SCALA a nice to have

Ceridian combines the excitement of a startup environment, with the growth opportunities of a large organization. We believe our employees should be happy and healthy, with peace of mind and a sense of fulfillment. We provide our employees with comprehensive benefits for various life circumstances and needs, great opportunities for career development, and a balanced lifestyle to achieve personal and professional success.

Ceridian is fueled by the diversity of our talented employees. We are an equal opportunity employer and embrace all individuals and that makes them unique. We consider all applicants, regardless of age, religion, race, color, ancestry, gender, gender identity, disability, national origin, sexual orientation, genetic information, citizenship, military or veteran status, or any other characteristic protected by federal, state, or local laws. We enthusiastically encourage all individuals to apply for positions that fit their passions. Come join our inclusive team and start collaborating with us on award winning projects!