Cloud Business Data Analyst

Why Work Here?At Arkatechture, we have a simple shared mission: to build a sustainable organization built upon three pillars: Do something meaningful, With a great team, Earning what you deserve.We started in 2012 with a passion for data, business, and getting things done. We are a team of data lovers and technical experts who use our skills to help businesses big and small harness, utilize, and optimize their data. As New England’s Data Resource, we are a small company constantly evolving to keep up with changing landscapes in the data world. We are proud of the community and culture that we’ve created at Arkatechture, and we have no intention of slowing down. We offer a competitive benefits package that includes: A flexible work-from-home policyOpen-concept office in Portland, ME with an easy-going dress code, and fresh pots and pops all day (that’s coffee and popcorn!)Training & certificate reimbursementA competitive benefits package that includes medical, disability, life insurance and optional dental/vision401K Retirement planning with company matchingGenerous paid time off and eleven paid holidaysEmployee recognition through milestone awards including annual PTO increases, as well as a 4 day work-week at 3 years of service!All employees share our core values: put the team first, practice humility, take pride in everything we do, stay curious, care for our community & environment, take work seriously; ourselves not so much. The PositionArkatechture is seeking candidates for a Cloud Business Data Analyst position to support Business Intelligence and Data warehousing initiatives focused on our Financial Services clients.As a Cloud Business Data Analyst, responsibilities include data analysis, data profiling, data mapping, developing SQL views, and writing Python code. This role requires proficiency in interpreting data, trends, patterns in complex data sets, technical expertise with data models, databases and reporting tools like Tableau orPowerBI. The ability to interpret and use artifacts like business requirement documents, system requirements documents, critical data element identification and classification, requirement traceability matrix, workflows, data mapping, etc. is required. The ideal candidate will be able to work efficiently with the business and the technology teams collaborating with the project/program managers. This position has the opportunity to be 100% remote if desired.How to ApplyPlease send a cover letter and resume with your application. You must submit both documents to be considered for the position.Key ResponsibilitiesExpert level professional role, considered subject matter expert with in-depth knowledge/expertise in Financial ServicesAdvanced analytical and problem solving skillsFluent in SQL and PythonWorks autonomously on a range of tasksMay lead end-to-end processes or functional programsIn-depth experience working with very large datasets and familiarity with big data technologiesSupports business teams in the use and understanding of the data and reporting solutionsDevelops data road map/information management strategies and corresponding technical solutions on integrating, transforming, and/or managing dataDrives data-centric solution development focusing on complex data integrationSolicits, analyzes, and understands data requirements (i.e., using market research, requirements gathering, feature planning, user experience / design considerations, etc.) to enable development of information management solutionsManaging client interactions and growing client relationship during projectsDevelop Source to Target MappingsData Profiling, analyzing source system data and metadata and collect requirements for data ingestion into a data warehouseDeveloping and deconstructing complex SQL, Common Table Expressions, Stored Procedures, and Views for Business Conformance layersData Cleansing, Data Quality assessments and developing data quality rulesImplementing cloud data warehouses, data collection systems, data analytics and other strategies that optimize business intelligence and analytical efficiency and qualityBuilding reference data for hierarchies, lookups and grouping purposesAcquiring data from primary or secondary data sources and developing and maintaining Data Dictionaries, Critical Data Identification and Classification, Data Lineage, and Data Quality rulesIdentify, analyze, and interpret trends or patterns in complex data setsFilter and “clean” data by reviewing reports and key performance indicators to locate and correct code problemsTesting using SQL and providing development sign offMentoring & review SQL code and deliverables of junior & mid-level Data AnalystsLocate and define new process improvement opportunitiesDocumentation of processes and workflowsAdditional responsibilities as assignedSkills, Knowledge and ExpertiseMinimum QualificationsBachelor's Degree in a relevant field or 2-5 years of experience in a similar roleExpert level familiarity with CollibraExpert in complex SQL syntaxUnderstanding of Azure cloud platform1-3 years of experience with CollibraFluent in PythonDomain expertise in Financial Services working with Banks and/or Credit Unions focused on Credit Card portfolios and specifically Retail Card Services on TSYSEnthusiastic, learner and driven with a positive attitudeStrong critical and analytical thinking and problem solving skillsExperience working on multiple databases such as Snowflake, SQL Server, Databricks, Oracle, PostgreSQL, MySQL, etcA strong understanding of Agile software development life cycle and methodologyExperience working on Data Management projects for Data Lakes/Data WarehousingExperience driving and growing client interaction as part of sales support and project deliveryAnalytical and problem-solving skills are required to interpret data and draw conclusionsReview, analyze and evaluate detailed business and functional requirements, documentation, process flows and data models to contribute to the development of project plans including project charter, project deliverables, cost/benefits analysis, time line estimates, scope and control.Develop use cases, defining and documenting user procedures and workflows, and how each class of user interacts with east system functionAssist in the development of conversion and implementation strategiesSkill in using analytical software tools, data analysis methods and reporting techniquesAbility to communicate effectively in both oral and written formAbility to work collaboratively and build relationshipsAbility to work successfully as a member of a team and independentlyAbility to exercise sound judgment in making decisionsAbility to analyze, organize and prioritize work while meeting multiple deadlinesAbility to handle confidential information with discretion Preferred Experience Proactively identifies and tracks project risk and develops mitigation plans to manage risk (i.e., risk related to technology, change management, procurement, business process management, requirements management)Provides on-going communication to key stakeholders, including the Project Sponsor, Business Project Owner, Program Manager and Portfolio Manager to ensure they are aware of significant changes to the project status in a timely mannerDevelops, monitors and tracks project plans throughout project lifecycleMonitors and controls the work related to each deliverable

Apply Now