Job Description
Must Have Skills*
T-SQL, SQL Server, MS SQL Server Management Studio, SQL Server Integration Services (SSIS), Azure Data Factory, Azure DevOps, Team Foundation Server
The selected candidate
. Leads the delivery of processes to extract, transform and load data from disparate sources into a form that is consumable by analytics processes, for projects with moderate complexity, using strong technical capabilities
. Designs, develops and produces data models of relatively high complexity, leveraging a sound understanding of data modelling standards to ensure high quality
. Builds networks with other departments across the business to help define and deliver business value, and may interface and communicate with program teams, management and stakeholders as required to deliver small to medium-d projects
Your key responsibilities include
. Leading the production of high-quality data engineering deliverables, helping to ensure project timelines are met, and providing informal mentoring / training to junior members of the team
. Leading the delivery of data quality reviews including data cleansing where required to ensure integrity and quality
. Leading the delivery of data models, data storage models and data migration to manage data within the organization, for a small to medium-d project
. Resolving escalated design and implementation issues with moderate to high complexity
. Analyzing the latest industry trends such as cloud computing and distributed processing and beginning to infer risks and benefits of their use in business
. Providing technical expertise to maximize value from current applications, solutions, infrastructure and emerging technologies and seek to continuously improve internal processes
. Developing working relationships with peers across other engineering teams and beginning to collaborate to develop leading data engineering solutions
. Driving adherence to the relevant data engineering and data modelling processes, procedures and standards
Skills and attributes for success
. Batch Processing – Capability to design an efficient way of processing high volumes of data where a group of transactions is collected over a period of time
. Data Integration (Sourcing, Storage and Migration) – Capability to design and implement models, capabilities and solutions to manage data within the enterprise (structured and unstructured, data archiving principles, data warehousing, data sourcing, etc.). This includes the data models, storage requirements and migration of data from one system to another
. Data Quality, Profiling and Cleansing – Capability to review (profile) a data set to establish its quality against a defined set of parameters and to highlight data where corrective action (cleansing) is required to remediate the data
. Stream Systems – Capability to discover, integrate, and ingest all available data from the machines that produce it, as fast as it’s produced, in any format, and at any quality
Education
. B.S. in Actuarial, Behavior Economics, Computer Science, Data Analytics, Data Science, Econometrics, Engineering, IT, Cyber Security, or related field preferred
What we look for
. Strong analytical skills and problem-solving ability
. A self-starter, independent-thinker, curious and creative person with ambition and passion
. Excellent inter-personal, communication, collaboration, and presentation skills
. Customer focused
. Excellent time management skills
. Positive and constructive minded
. Takes responsibility for continuous self-learning
. Takes the lead and makes decisions in critical times and tough circumstances
. Attention to detail
. High levels of integrity and honesty
Source link
