Bachelor's degree or higher in a relevant field with 9+ years of experience
Proficient in SQL queries and data warehouse concepts
Experience with AWS services (S3, Glue, Lambda) for data solutions
Strong understanding of AWS storage and database services
Familiarity with CI/CD practices and deployment automation using GITLAB
Proficient in Java EE and one or more programming languages like Python or Scala
Responsibilities
Design and manage complex data architectures and repositories
Configure database parameters and ensure data accuracy
Troubleshoot database applications and maintain schemas
Monitor data quality and establish integrity of data definitions
Enhance infrastructure efficiency and automate processes
Produce data analytic models and ad-hoc reports for management
Collaborate in an Agile team to improve data governance and reporting processes
Benefits
Opportunity to work with cutting-edge AWS technologies
Collaborative Agile team environment
Focus on professional development and continuous learning
Engagement in impactful data-driven decision-making processes
Exposure to a variety of technical and business application projects
Full Job Description
xScion is seeking a Senior Data Engineer who will be responsible for all aspects of business intelligence structure including analysis of requirements, design, troubleshooting, support and administration of schemas, data definitions, meta data, and architecture of all data analytic models, databases, and repositories used to create, retain, and analyze business intelligence data.
As as a Senior Data Engineer, You Will:
Be Responsible for complex data design, database architecture, metadata and repository creations, repository management, construction, and administration
Configure database parameters, allocate database resources, and review data loaded into databases for accuracy
Lead troubleshooting database applications, product support, analysis of data requirements, maintenance of application and processing architectures, and database schemas
Establish integrity of complex data definitions and underlying data models, and monitors/audits overall data quality
Lead improvements to increase efficiency of infrastructure and automation processes.
Produce complex data analytic models, ad-hoc queries, and reports for distribution to Audit and business management. Performs basic SQL queries for analysis of existing metrics and the development of new metrics
Lead software testing including code-level/unit testing, ETL processes, SQL or reporting tools, code-level unit testing, and script development of moderate complexity
Work and collaborate as a part of an Agile team to develop and implement capabilities to enable decision making processes and procedures including data, reporting, dashboards, metadata collection processes, metric collection processes, resolve data issues, data governance and data clean up and maintenance, data sharing agreement processes, etc.;
Develop conceptual, logical, and physical IT engineering designs, that support the infrastructure requirements of varying levels of technical and business application projects
Complete analysis of business requirements, as it relates to technical infrastructure design, and ensure traceability of the design to the business requirements.
To Be Successful, You Need:
US Citizenship or Permanent Residency
Bachelor's or higher degree in relevant discipline and 9+ years of relevant work experience
Knowledge of programming, SQL queries, data warehouses, relational databases, and quantitative/qualitative data analytic techniques
Experience using core AWS services to build and support data solutions leveraging architecture best practices (S3, Glue, Lambda)
Expertise in AWS Storage (S3, EBS), AWS Databases (Aurora Postgress,), AWS Data Integration (Glue)
Good understanding of AWS Identify and Access management, AWS Networking and AWS Monitoring tools
Proficiency in CI/CD and deployment automation using GITLAB pipeline
Proficiency in Cloud infrastructure provisioning tools e.g., Terraform
Strong technical skill in software engineering for Java EE /Cloud technologies and proficiency in Java Lambdas, Java Streams API, Java functional programming
Proficiency in one or more programming languages e.g., Python, Scala.
Knowledge in Workday data tools including Adaptive & Prism desirable, but not required.
