Data Conversion Analyst

Sungard Public Sector Seattle , WA 98113

Posted 2 months ago

911 call records. Crime reports. Jail booking information. Evidence logs. More and more agencies are switching to CentralSquare Software to track this kind of data. And when they do, CentralSquare Technologies' data conversion consultants make sure they have immediate access to the wealth of legacy data they've built up, right at their fingertips in their new CentralSquare system, from the moment they switch it on.

And that's important work when you're dealing with mission-critical data. Our data conversion consultants take pride in knowing that their work is a key factor in making our customers' new systems useful to them right from the start. That when someone calls 911, the dispatcher will be notified of prior incidents at the caller's address. That investigators will still have access to the years of case reports that will help them see connections between related crimes.

Thanks to our data conversion consultants, our customers spend less time hunting for records and more time protecting and serving. Sound like a cool way to use your data skills for good? We'd love to have you join us.

Here's an overview of the tasks and responsibilities:

  • Work collaboratively with customer agencies undergoing CentralSquare software implementation to obtain data from their legacy system, understand what it means and how it is used, and determine how best to translate it into their CentralSquare system

  • Analyze legacy data to estimate / benchmark project scope and length

  • Develop scripts to load legacy data into conversion tools and convert data into CentralSquare software

  • Develop and maintain an understanding of CentralSquare software including functionality and database schema; use this knowledge to make informed decisions regarding data mapping and to review data within target system

  • Communicate with customer agencies throughout implementation projects to clarify questions that arise regarding data mapping, demonstrate converted data in target system, understand any modifications needed, and verify results of modifications

  • Manipulate and load data such as code tables from secondary additional sources to assist in configuration of agencies' CentralSquare systems

  • Assist in running final data conversion at time of system go-live

  • Communicate proactively with supervisor and project manager regarding project progress and any project risks or issues that arise

  • Create and maintain documentation for data conversion processes; seek out process improvements

Interested? Here's what we need from you:

  • Experience with SQL and at least one RDBMS

  • Knowledge of ETL (Extract, Transform, and Load) processes

  • Ability to learn new applications and processes quickly

  • Passion for technology; eager to learn new tools and technologies

  • Strong customer-facing skills and personal interaction/interpersonal skills

  • Ability to adapt quickly to changing business and customer needs, maintaining a high degree of flexibility

  • Self-motivated; able to work independently

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Senior Data Analyst Analytics & Artificial Intelligence (Aai) 200000Ca Attention Military Veterans
New!

Tech-Connect

Posted Today

VIEW JOBS 4/4/2020 12:00:00 AM 2020-07-03T00:00 <strong>Senior Data Analyst – Analytics & Artificial Intelligence (AAI) – 200000CA </strong><br /> <strong>Location:  Columbus, IN</strong><br />   <br /> No, this isn’t one of those ordinary jobs.<br /> We are a team of dependable, innovative thinkers, who are empowered to generate and deliver solutions for customers, community, and environment. Our employees develop their careers through the challenges only a diverse, global innovator can promise. This is a collaborative culture where thinking beyond your desk is more than part of the job. It is the job.<br /> <em>This is what we call Working Right.</em><br />  <br /> <strong>Description</strong><br /> We are a place big enough to coach and develop a global workforce and create the world’s leading clean, engine technology. We’re also small enough for you to find your fit and personal passion with a team of dependable, innovative thinkers who are developing their careers within a diverse, inclusive, empowering environment.<br /> Learn more about this role and how you can begin <em>Powering your potential</em>.<br /> Our Business Unit delivers reliable, durable, high performing products to our global partners. Working in an innovative space, you’ll develop high tech solutions that will fuel your advanced career skill set and empower you to own your career. Our integrated businesses demand the talents and creativity of individuals with a wide range of skills and experience.<br /> This is an exciting opportunity in Columbus, IN for a Senior Data Analyst. <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Supports Business Intelligence (BI) solutions programs composed of multiple-functional projects. Collaborates with other Information Management experts and peers to support functional leaders through project completion and organizational improved capability to expected maturity.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Facilitates data and environment governance processes for the assigned domain.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Conducts audits and address findings in a timely manner.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Facilitate an intake process for assigned domain to reduce rework and promote reuse.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Integrates data from warehouse, data lake and other source systems to build models for use by the business.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Cleanse data to ensure accuracy and reduce redundancy.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Conducts analytics to create reports and dashboards using business intelligence technology.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Delivers insights to the business to improve decision making.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Develops the descriptive and diagnostic analytics for their respective teams.</li> </ul> Maintains documentation of key decisions, rules, controls, processes and training. <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Leads project work to ingest key data for assigned domain into the data lake.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Leverages Data Catalog to help functional team find needed data.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Participates in monthly peer group collaboration meetings to promote the use of the BI ecosystem.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Develops the capability of BI Ecosystem users in the assigned domain.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Manages, coaches, and mentors’ direct reports on BI processes and tools; providing guidance on problems and resolution; and delegating work assignments based on employee skills and development need.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Applies machine learning and machine learning tools on data and metadata to improve data quality and provides recommendations and designs solutions to resolve issues.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Develops data profiles for data tables and elements in the data lake.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Analyzes complex and diverse data sets from multiple sources to identify data quality, coherency and integrability issues and reduce data redundancy; provides recommendations to resolve issues throughout the data lifecycle.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Identifies patterns and trends in data sets; applies statistical process controls on data.</li> </ul> <strong>Qualifications</strong><br /> <strong>Skills:</strong><br /> <strong>Data Literacy -</strong> Expresses data in context, including data sources and constructs, analytical methods and applied techniques; describes the use-case application and resulting value.<br /> <strong>Data Profiling -</strong> Assesses data issues and cleansing requirements to perform data extraction, mapping, collection, and testing; establishes good, quality data.<br /> <strong>Data Communication and Visualization -</strong> Constructs a tale of the business problem, root cause, solution options, and opportunities through illustrating data visually, including reports and dashboards.<br /> <strong>Data Analytics -</strong> Interprets information relying on knowledge of business or functional frameworks and leverages analytical problem-solving tools to draw conclusions and communicate meaningful patterns that drive business insights; assesses quality of data as an initial step of the analysis.<br /> <strong>Data Quality -</strong> Identifies, understands and corrects flaws in data that supports effective information governance across operational business processes and decision making.<br /> <strong>Project Management -</strong> Establishes and maintains the "Balanced Triangle" of Scope, Schedule and Resources for a temporary effort (a "project").<br /> <strong>Communicates effectively - </strong>Developing and delivering multi-mode communications that convey a clear understanding of the unique needs of different audiences.<br /> <strong>Interpersonal savvy -</strong> Relating openly and comfortably with diverse groups of people.<br /> <strong>Organizational savvy -</strong> Maneuvering comfortably through complex policy, process, and people-related organizational dynamics.<br /> <strong>Collaborates -</strong> Building partnerships and working collaboratively with others to meet shared objectives.<br /> <strong>Manages ambiguity - </strong>Operating effectively, even when things are not certain, or the way forward is not clear.<br /> <strong>Balances stakeholders -</strong> Anticipating and balancing the needs of multiple stakeholders.<br /> <strong>Experience:</strong> <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">5 years equivalent work experience in relevant technical discipline.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Exposure to Big Data open source preferred.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Clustered compute cloud-based implementation experience preferred.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Experience with Databricks as well as Informatica data management tool set.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Knowledge of SQL query language execution on NOSql and SQL sources required</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Exposure to Agile software development required.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Exposure to IoT technology required.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Data profiling tools, technologies and coding experience required</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Data Catalog tools and technologies experience required</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Business intelligence tools and technologies experience required</li> </ul> <strong>Education, Licenses, Certifications</strong> <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">College, university, or equivalent degree in statistics, information systems or related field required.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Master’s degree in relevant field of study preferred</li> </ul> <strong>Compensation and Benefits</strong><br /> Base salary rate commensurate with experience. Additional benefits vary between locations and include options such as our 401(k) Retirement Savings Plan, Cash Balance Pension Plan, Medical/Dental/Life Insurance, Health Savings Account, Domestic Partners Coverage and a full complement of personal and professional benefits.<br />  <br />  <br /> <strong>E-verify</strong><br /> We are an equal opportunity and affirmative action employer dedicated to diversity in the workplace. Our policy is to provide equal employment opportunities to all qualified persons without regard to race, gender, color, disability, national origin, age, religion, union affiliation, sexual orientation, veteran status, citizenship, gender identity and/or expression, or other status protected by law.<br />  <br /> We validate right to work using E-Verify.<br /> We will provide the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS), with information from each new employee’s Form I-9 to confirm work authorization. To learn more about E-Verify, including your rights and responsibilities, please visit <a href="http://www.dhs.gov/E-Verify">www.dhs.gov/E-Verify</a> .<br />  <br />  <br />  <br />  <br />  <br />   Tech-Connect Seattle WA

Data Conversion Analyst

Sungard Public Sector