Data Lead / Cloud Analyst
EXCLUSIVELY ON MEYTIER
You're in luck. This opportunity exclusively available through Meytier.
to learn more about this employer
About Meytier Premier Employers
Premier Employers are industry leaders that have forged exclusive partnerships with Meytier to forward our shared mission to offset bias in hiring, and are only visible to members of the Meytier community.
EXCLUSIVELY ON MEYTIER
You're in luck. This opportunity exclusively available through Meytier.
The Data Services team is a core competency of IT that
enables Client Financial to deliver a platform for independent financial
advisors to build great businesses. At the heart of this platform is an
Enterprise Data Hub. The EDH acts as the firm’s single source of truth
for data and is the foundation for all data and analytical reporting, dashboards
and KPIs.
The Junior Cloud Analyst will act as part of Data
Services Platform team that is responsible for the design, development and
management of the company’s database and data warehouse platforms. The
successful candidate will be part of a small team that ingests, models,
prepares, stores and disseminates data throughout the organization line of
business systems, strategic business partners and management.
Key Responsibilities:
Builds
PowerShell scripts, SSIS jobs, build Azure/AWS data pipelines. Assists in
designing, developing and deploying of data preparation processes to be
utilized for data warehouses/repositories/big data platforms, self-service
reporting solutions, scorecards and dashboards on financial data using
analytical and visualization tools. Comfortable
working collaboratively with multiple offshore application development teams. Works in an
object-oriented, multi-developer environment with version control, change
management and continuous improvement protocols. Required Qualifications:
Minimum 1
year working as a Data Analyst Minimum 1
year of Microsoft Azure/AWS development/ implementation experience 1 year of
experience with Big Data concepts and common components including Azure, Spark
and multiple languages (Java, Scala, Python, R) and integration with
consumption tools. SQL,
PowerShell and/or Python scripting experience. Strong
technology background with 1 year of ETL and SQL coding experience 1 year of
.Net (C#, VB Script) OR Java application development experience 1 year of
ETL coding experience using SSIS, Azure Data Factory and other tools Experience
in trouble shooting and resolving issues with existing systems Experience
designing high performing database queries / indexes and troubleshooting
database performance issues. Excellent
written and verbal communication skills. Ability to
deliver in a fast-paced and goals-based environment with time-bound
deliverable Ability to
work flexible hours to meet deadlines while working with Onshore and Offshore
vendor teams including development and QA resources Skilled in
collaboration, enjoys working with others and achieving results as a team Passion and
demonstrated experience in delivering results and meeting business goals in a
matrix and cross functional environment Preferred Qualifications:
Azure Data
Factory pipeline build/deploy & Azure Databricks
develop/implement/troubleshoot experience Undergraduate
degree in Information Systems, Computer Science, or Data Science 1 year of
Spark development
{"group":"Organization","title":"Data Lead / Cloud Analyst","zohoId":"557706000001187057","endDate":"2020-09-01T00:00:00.000Z","jobType":"Full Time","job_url":"102-orion-innovation-data-lead-cloud-analyst","agencyId":1,"location":[{"lat":33.74888889,"lon":-84.39,"city":"Atlanta","text":"Atlanta, GA 30319, USA","state":"Georgia","country":"","zipCode":"30319","is_state":false,"is_country":false,"state_code":"GA","countryCode":"","isLocationSet":true,"loc_h3_hex_res4":"8444c1bffffffff","isLocationResolved":false,"is_address_available_from_parser":true}],"maxSalary":"120000","minSalary":"100000","startDate":"2020-08-17T00:00:00.000Z","onBehalfOf":"42","description":"<span id=\"spandesc\"><p style=\"text-align: justify\" class=\"MsoNormal align-justify\"><span class=\"colour\" style=\"color: black\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">The Data Services team is a core competency of IT that\nenables Client Financial to deliver a platform for independent financial\nadvisors to build great businesses. At the heart of this platform is an\nEnterprise Data Hub. The EDH acts as the firm’s single source of truth\nfor data and is the foundation for all data and analytical reporting, dashboards\nand KPIs.</span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></p><p style=\"text-align: justify\" class=\"MsoNormal align-justify\"><span class=\"colour\" style=\"color: black\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">The Junior Cloud Analyst will act as part of Data\nServices Platform team that is responsible for the design, development and\nmanagement of the company’s database and data warehouse platforms. The\nsuccessful candidate will be part of a small team that ingests, models,\nprepares, stores and disseminates data throughout the organization line of\nbusiness systems, strategic business partners and management.</span></span></span><br /></p><p style=\"text-align: justify\" class=\"MsoNormal align-justify\"><b><span class=\"colour\" style=\"color: black\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Key Responsibilities:</span></span></span></b><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></p><ul><li><span class=\"colour\" style=\"color: black\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Builds\nPowerShell scripts, SSIS jobs, build Azure/AWS data pipelines.</span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li><span class=\"colour\" style=\"color: black\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Assists in\ndesigning, developing and deploying of data preparation processes to be\nutilized for data warehouses/repositories/big data platforms, self-service\nreporting solutions, scorecards and dashboards on financial data using\nanalytical and visualization tools.</span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li><span class=\"colour\" style=\"color: black\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Comfortable\nworking collaboratively with multiple offshore application development teams.</span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li><span class=\"colour\" style=\"color: black\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Works in an\nobject-oriented, multi-developer environment with version control, change\nmanagement and continuous improvement protocols.</span></span></span><b><span class=\"colour\" style=\"color: black\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"> </span></span></span></b><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li></ul><p style=\"text-align: justify\" class=\"MsoNormal align-justify\"><b><span class=\"colour\" style=\"color: black\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Required Qualifications:</span></span></span></b><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></p><ul><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"colour\" style=\"color: black\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Minimum 1\nyear working as a Data Analyst</span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"colour\" style=\"color: black\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Minimum 1\nyear of Microsoft Azure/AWS development/ implementation experience</span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"colour\" style=\"color: black\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">1 year of\nexperience with Big Data concepts and common components including Azure, Spark\nand multiple languages (Java, Scala, Python, R) and integration with\nconsumption tools.</span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"colour\" style=\"color: black\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">SQL,\nPowerShell and/or Python scripting experience.</span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"colour\" style=\"color: black\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Strong\ntechnology background with 1 year of ETL and SQL coding experience</span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"colour\" style=\"color: black\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">1 year of\n.Net (C#, VB Script) OR Java application development experience</span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"colour\" style=\"color: black\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">1 year of\nETL coding experience using SSIS, Azure Data Factory and other tools</span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"colour\" style=\"color: black\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Experience\nin trouble shooting and resolving issues with existing systems</span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"colour\" style=\"color: black\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Experience\ndesigning high performing database queries / indexes and troubleshooting\ndatabase performance issues.</span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"colour\" style=\"color: black\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Excellent\nwritten and verbal communication skills.</span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"colour\" style=\"color: black\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Ability to\ndeliver in a fast-paced and goals-based environment with time-bound\ndeliverable</span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"colour\" style=\"color: black\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Ability to\nwork flexible hours to meet deadlines while working with Onshore and Offshore\nvendor teams including development and QA resources</span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"colour\" style=\"color: black\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Skilled in\ncollaboration, enjoys working with others and achieving results as a team</span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"colour\" style=\"color: black\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Passion and\ndemonstrated experience in delivering results and meeting business goals in a\nmatrix and cross functional environment</span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li></ul><p style=\"text-align: justify\" class=\"MsoNormal align-justify\"><b><span class=\"colour\" style=\"color: black\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Preferred Qualifications:</span></span></span></b><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></p><ul><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"colour\" style=\"color: black\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Azure Data\nFactory pipeline build/deploy & Azure Databricks\ndevelop/implement/troubleshoot experience</span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"colour\" style=\"color: black\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Undergraduate\ndegree in Information Systems, Computer Science, or Data Science</span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li class=\"align-justify\" style=\"text-align: justify\"><span class=\"colour\" style=\"color: black\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">1 year of\nSpark development</span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li></ul><div><br /></div></span><br />","isHybridJob":false,"isRemoteJob":true,"noOfOpenings":1,"maxExperience":"8","minExperience":"5","isOnPremiseJob":false,"onBehalfOfName":"Orion Innovation","otherlocations":[],"zohoCurrencyIn":"USD","experienceLevel":"Mid / Senior","zohoNoOfOpenings":{"noOfOpenings":1,"fulfillmentIds":["557706000001187057-1"]},"otherJobReference":null,"sharpenedJobTitle":"Data Lead / Cloud Analyst","job_category_group":3,"portalLocationDisplay":"Atlanta GA","expertise_coreskill_or_product":["Other"],"job_id":"2272"}