Expired
Company:
Axelon Services Corporation
Location: Addison
Closing Date: 19/10/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
Title: Application Architect V
Schedule: This is a hybrid role (3-days on-site; 2-days WFH)
Locations: Addison, TX
Job Description:
This role is responsible for leading the transformation of the enterprise ETL platforms which requires engagement across multiple line of business.
Key responsibilities include setting up automations, coordinating delivery, providing visibility of program health, and managing program risks.
This role facilitates sync points between business and technology leaders across, as well as Risk and Compliance partners. Individuals in the role also ensure delivery meets the client s expectations in terms of the target outcomes, timeline and cost.
Develop and deliver data ETL solutions to accomplish technology and business goals.
Code solutions to ingest, curate, aggregate, integrate, clean, transform, and control data in operational and/or analytics data systems per the defined acceptance criteria.
Assemble large, complex data sets to meet functional reporting requirements.
Build processes supporting data transformation, data structures, metadata, data quality controls, dependency, and workload management.
Define and build reporting applications that enable better data-informed decision-making.
Contribute to existing test suites (integration, regression, performance), analyze test reports, identify any test issues/errors, and triage the underlying cause.
Developed, design, and document ETL Process based on established standards and guidelines and CI/CD toolset such as JIRA, Confluence, BitBucket, Jenkins
Automate ETL processes leveraging enterprise tools such as AutoSyst
Provide operational and escalation support when required
Document and communicate required information for deployment, maintenance, support, and business functionality.
Work closely with business partners to help translate functional requirements into technical approach, design, and decisions.
Create SQL schema objects, complex attributes / metrics, conditional and level metrics, and their use within a report
Using SQL, Python, Hadoop/Hive and data warehouse concepts /architecture, dimensional modeling, and ETL solution design.
Tune and optimize query performance for large datasets-cubes, caching, aggregate structures within MicroStrategy, Tableau and various RDBMS, Hadoop backend systems.
Top MUST Have:
Bachelor s degree or equivalent in Computer Science, Computer Information Systems, Management Information Systems, Engineering (any) or related; and
5 years of progressively responsible experience in the Job offered or a related IT occupation.
Working closely with business partners to help translate functional requirements into technical approach, design, and decisions- Banking & Markets business acumen;
Creating SQL schema objects, complex attributes / metrics, conditional and level metrics, and their use within a report;
Developing Excel & Tableau dashboards and 3rd party application report integration;
Using SQL, Python, Hadoop/Hive and data warehouse concepts /architecture, dimensional modeling, and ETL solution design.
Tuning and optimizing query performance for large datasets-cubes, caching, aggregate structures within MicroStrategy, Tableau and various RDBMS, Hadoop backend systems.
Schedule: This is a hybrid role (3-days on-site; 2-days WFH)
Locations: Addison, TX
Job Description:
This role is responsible for leading the transformation of the enterprise ETL platforms which requires engagement across multiple line of business.
Key responsibilities include setting up automations, coordinating delivery, providing visibility of program health, and managing program risks.
This role facilitates sync points between business and technology leaders across, as well as Risk and Compliance partners. Individuals in the role also ensure delivery meets the client s expectations in terms of the target outcomes, timeline and cost.
Develop and deliver data ETL solutions to accomplish technology and business goals.
Code solutions to ingest, curate, aggregate, integrate, clean, transform, and control data in operational and/or analytics data systems per the defined acceptance criteria.
Assemble large, complex data sets to meet functional reporting requirements.
Build processes supporting data transformation, data structures, metadata, data quality controls, dependency, and workload management.
Define and build reporting applications that enable better data-informed decision-making.
Contribute to existing test suites (integration, regression, performance), analyze test reports, identify any test issues/errors, and triage the underlying cause.
Developed, design, and document ETL Process based on established standards and guidelines and CI/CD toolset such as JIRA, Confluence, BitBucket, Jenkins
Automate ETL processes leveraging enterprise tools such as AutoSyst
Provide operational and escalation support when required
Document and communicate required information for deployment, maintenance, support, and business functionality.
Work closely with business partners to help translate functional requirements into technical approach, design, and decisions.
Create SQL schema objects, complex attributes / metrics, conditional and level metrics, and their use within a report
Using SQL, Python, Hadoop/Hive and data warehouse concepts /architecture, dimensional modeling, and ETL solution design.
Tune and optimize query performance for large datasets-cubes, caching, aggregate structures within MicroStrategy, Tableau and various RDBMS, Hadoop backend systems.
Top MUST Have:
Bachelor s degree or equivalent in Computer Science, Computer Information Systems, Management Information Systems, Engineering (any) or related; and
5 years of progressively responsible experience in the Job offered or a related IT occupation.
Working closely with business partners to help translate functional requirements into technical approach, design, and decisions- Banking & Markets business acumen;
Creating SQL schema objects, complex attributes / metrics, conditional and level metrics, and their use within a report;
Developing Excel & Tableau dashboards and 3rd party application report integration;
Using SQL, Python, Hadoop/Hive and data warehouse concepts /architecture, dimensional modeling, and ETL solution design.
Tuning and optimizing query performance for large datasets-cubes, caching, aggregate structures within MicroStrategy, Tableau and various RDBMS, Hadoop backend systems.