Position : Data Analyst

Working Hours : Mondays to Fridays; Flexible working hours; 8AM to 12PM overlap hours (EST)

Holidays : PH Holidays

Salary range : $800 - $1,500 USD

BACKGROUND OF THE COMPANY

The company is a real estate investment firm headquartered in Detroit. We are focused on driving urban revitalization by transforming overlooked properties into quality affordable housing.

We invest in markets where families with government-backed rental vouchers are unable to find adequate housing, a shortage signalled by the number of unused vouchers (>

10% of the overall # of vouchers).

Through a repeatable and scalable process, we buy vacant homes, fix them and rent them to families in need of housing. By doing so, we turn vacancy into creditworthy income and provide quality housing for those most in need

ABOUT THE ROLE

We are focused on addressing the country’s affordable housing crisis by repositioning overlooked properties into quality affordable housing.

Our business model is simple : We buy overlooked properties, fix them, and rent those homes as long-term affordable housing.

We are expanding across the Midwestern United States, and our Data Analyst will play an important role in assembling a rapidly growing portfolio of single-family homes.

We’re seeking a Data Analyst who will thrive in a fast-paced, rapidly expanding firm in which all professionals work collaboratively.

Attention to detail, great communication skills (verbal & written), and impressive organizational skills are essential to success in this role.

We are seeking a highly motivated and consistent team player who brings both a proactive approach and a positive mindset.

SPECIFIC DUTIES AND RESPONSIBILITIES

The Data Analyst will oversee the company’s internal data infrastructure and analytics alongside the investment partners and asset management team.

Broad responsibilities will include :

Operate, oversee and update our data infrastructure as our business grows

Ensure the delivery of clear, concise and accurate analytic products and services

Enter data from external sources into our internal database, verifying and correcting entries as needed

Identify and implement processes to efficiently import data from external sources into our database

Drive process improvement and quality control for key deliverables

Support ad-hoc analysis, summarizing results, and identify actionable insights

Identify areas of opportunity for the team to improve quality and drive efficiencies

Identify potential pitfalls that may lead to specific project issues or data / implementation concerns

Effectively communicate roadblocks, and identify ways to mitigate risks, escalating at-risk projects to management

Ensure that best practices are followed across multiple teams

QUALIFICATIONS

Requirements :

3+ years of experience as a Data Analyst or similar

Previous analytic, implementation, and / or quality assurance experience leading projects

Working knowledge of web site analytic platforms including Google Analytics, Power BI, and Tableau

Bachelor’s degree in Computer Science, Mathematics, Statistics, or Operations Research preferred

Experience in Digital Analytics (Web, Online Advertising, Search, Social)

Must demonstrate strong analytical skills with a solid understanding of identifying significance

Familiarity with Microsoft Excel and the ability to learn new software systems quickly

Detail-oriented, consistent, strong organizational & communication skills

Preferred Experience :

Experience at a real estate investment firm or property management company

Location : Dallas, TX (Onsite so need only location Candidate)

Job Description :

Basic Qualifications :

• Ability to complete tasks in a high-pressure environment.
• Excellent inter-personal and communication skills, both verbal and in writing
• Experience with enterprise information management, such as data modeling, data governance, reference data management, master data management, meta data management, data integration, etc .
• Critical thinking, problem solving, comfortable in making judgement call and able to clearly articulate the tradeoffs in proposed architecture design and solution.
• Proficient with Databases and writing SQL queries against SQL server 2012, Oracle 11i, Postgres, MySQL.
• Knowledge of application lifecycle, design / design patterns, tools, and methodologies.
• Proven ability to work with software engineering teams and understand complex development systems, environments, and patterns.
• Experience with Word, Excel, SharePoint, JIRA, Confluence, SOAP UI, JMeter, Postman is desired.
• Proficient in integration development using REST / SOAP APIs, and asynchronous integrations leveraging Messaging patterns with Apache Kafka / Active MQ / IBM MQ.
• Must have good understanding of XML / JSON / CSV data structures.
• Experience with Agile software development processes and the development life cycle
• Experience with SOA and Micro services Architecture is preferrable.
• Knowledge of ELK stack is desired.
• Understanding of Cloud patterns is a bonus.

Key Responsibilities :

• Analyze business and user needs, documenting requirements, and revising existing system logic difficulties.
• Identify and document business rules, dependencies, assumptions, risks, supportability, performance, and training needs.
• Create Integration technical design documents which includes process flow / sequence diagrams, entity transformation mapping definitions (JSON, XML, CSV) and documentation for the engineering teams to be able to build.
• Facilitate application onboarding process, understand the technical challenges, and propose an optimal solution.
• Collaborate with Solution architects and engineering team to implement the solution following design principles.
• Integrate multiple applications with middleware and derive mappings from source and target applications, using multiple technologies.
• Provide end user support for integration projects and translate needs into developing test plans.

This includes a coordinated effort with stakeholders by participating / facilitating User Acceptance Testing for application signoff.

• Create test plans, including definition of testing requirements; testing criteria, test data, scripts, user acceptance conditions and end-to end test requirements.
• Facilitate load and performance tests for applications.
• Act as a subject matter expert for integration customers, and answer queries for integrating applications, end users, developers, and architects.
• Performs the investigation and resolution of complex and critical data integration issues in the production environment.
• Work with Product Managers and Scrum Master to estimate, design, and build efficient, long term business applications utilizing standards.
• Break down tasks, estimate effort, identify, and raise blockers, issues, and risks.
• Generate tables and / or charts in excel to present meaningful data.
• Adhere to security, compliance and best-practices guidelines

Education & Experience :

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and / or ability required.

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• University degree in Computer Science, Computer Engineering, Information technology or related field or relevant experience.
• At least 10 years' experience in analysis, integration design involving P2P, E-Invoicing, CMMS & ERPs.
• Requirements Engineering, Project Management courses will be preferred.
• Consideration given to equivalent combination of education and experience.

Interested in a career with both meaning and growth? Whether your abilities are in direct patient care or one of the many other areas of healthcare administration and support, everyone at Parkland works together to fulfill our mission : the health and well-being of individuals and communities entrusted to our care.

By joining Parkland, you become part of a diverse healthcare legacy that’s served our community for more than 125 years.

Put your skills to work with us, seek opportunities to learn and join a talented team where patient care is more than a job. It’s our passion.

PRIMARY PURPOSE

Responsible for carrying out the operational responsibilities of data analysis and reporting functions for assigned area in order to assist management in the successful analysis and achievement of goals.

MINIMUM SPECIFICATONS

Education

• Must have a Bachelor's degree in a health related field or management information systems.
• Prefer a Master's degree in a related field.

Experience

Must have two (2) years of experience in analysis of healthcare or business related data and information systems.

Equivalent Education and / or Experience

May have an equivalent combination of education and experience to substitute for both the education and the experience requirements.

Certification / Registration / Licensure

Current license or certification in area of clinical expertise may be required.

Required Tests for Placement

Must be able to successfully pass the Standard-level Microsoft Excel test, as established by Employment Services, with a minimum score of 80%.

Skills or Special Abilities

• Must have good verbal and written communication skills.
• Must be able to demonstrate a working knowledge of program evaluation methods, statistical analysis, research skills, management information systems, and strategic planning.
• Must be able to demonstrate proficiency in personal computer usage.
• Must be able to demonstrate a working knowledge of statistical analysis, database design and analysis and management information systems design and interface.
• Must be able to demonstrate a working knowledge with regard to the software application used in the assigned area.
• Prefer a working knowledge of Seagate Crystal Reports and Microsoft SQL.
• Pharmacy :

Must have and maintain an EPIC training status of Proficient Self-Study or higher for the Clinical Data Model

Responsibilities 1. Responsible for the statistical analysis and production of reports, using data from a variety of sources, for use in management and / or clinical decisions.

Applies appropriate statistical and validation tools to ensure data accuracy. 2. Receives, collects, and reviews data from various sources, defines essential and required data elements to ensure records are current and valid for both reasonableness and accuracy, using knowledge and experience.

3. Interprets information used to develop reports. Performs analysis and trending reports that include graphic presentations and statistical summaries for use by management and / or clinical staff.

4. Designs, installs, implements, and evaluates existing or new database applications, tables, and files. Recommends improvements as needed.

5. Maintains status of assigned tasks and provides feedback to management to ensure proper priorities are maintained and that management is aware of project issues.

6. Responsible for the application development and support of custom software tools used within assigned department. 7. Responsible for designing and maintaining departmental databases used for reporting and analysis.

Responsible for departmental system support where applicable. Identifies and recommends improvements in the department's data storage and reporting capabilities.

8. Directs the day-to-day operations and utilization of the database system, maintaining its integrity, including performance tuning and monitoring, back-up, and recovery.

Isolates and resolves problems affecting database as whole or in part. 9. Interacts with department staff regarding data requirements, data needs, the preparation of data analysis reports and follow-up concerning deadlines and priorities to ensure department data needs are revised and up to date.

10. Serves as a technological resource to assigned department, providing ongoing support to management on new technology applications, hardware, telecommunications, and software as needed.

May represent the department in cross campus initiatives to link / interface data hardware and software programs. 11. Works with management team to implement new projects and directives.

Monitors and reports the results of project or directive implementation to management. Job Accountabilities 1. Identifies ways to improve work processes and improve customer satisfaction.

Makes recommendations to supervisor, implements, and monitors results as appropriate in support of the overall goals of the department and Parkland.

2. Stays abreast of the latest developments, advancements, and trends in the field by attending seminars / workshops, reading professional journals, actively participating in professional organizations, and / or maintaining certification or licensure.

Integrates knowledge gained into current work practices. 3. Maintains knowledge of applicable rules, regulations, policies, laws and guidelines that impact the area.

Develops effective internal controls designed to promote adherence with applicable laws, accreditation agency requirements, and federal, state, and private health plans.

Seeks advice and guidance as needed to ensure proper understanding.

Parkland Health and Hospital System prohibits discrimination based on age (40 or over), race, color, religion, sex (including pregnancy), sexual orientation, gender identity, gender expression, genetic information, disability, national origin, marital status, political belief, or veteran status.

Your Impact :

As part of a world-class Data Analytics team supporting experience optimization, data driven storytelling and digital insights;

you will how drive a better digital experience for our clients and customers and leverage data to drive positive outcomes.

• Primarily responsible for digital analytics and experimentation to optimize the customer experience and drive revenue and other key outcome
• Partner with strategy, product, creative and engineering teams within agile PODS to shape meaningful customer journeys and customer centric thinking
• Leverage Adobe Analytics to compile actionable insights
• Build digital measurement frameworks based on client / product goals and objectives
• Leverage data to build strategic experiment pipelines to fuel digital optimization
• Measure in-flight experiments and final outcomes including contributing to shared learning repositories and case studies
• Analyze customer journeys under an optimization-focused lens, interpret experimentation results to help clients evolve products
• Strong story-telling; presenting insights to clients and account teams with recommendations backed by robust analysis
• Collaborate with cross-functional teams, including creative, design and engineering to shape meaningful customer journeys and customer centric thinking

Qualifications

Your Skills & Experience :

3+ years of experience in Digital / Data Analytics

You love data! Passion for digital analytics, working with data and deriving insights and can demonstrate the impact you’ve had

Experience with Adobe Experience Platform, Adobe Analytics, Adobe Target, Adobe Journey Optimizer, Adobe Real-Time CDP, Customer Journey Analytics

Ability to build relationships and work as part of a cross functional team to solve complex problems - both with internal teams & external clients

Experience with optimization programs and delivering analytics engagements

Highly motivated with an entrepreneurial spirit & the ability to hit the ground running

Strong consultative skills and the ability to challenge status quo and gain adoption - proven ability to influence stakeholders both internal and external

A desire for continued learning in the ever changing world of digital business transformation

Additional Information

Benefits of Working Here

• Flexible vacation policy; time is not limited, allocated, or accrued
• 16 paid holidays throughout the year
• Generous parental leave and new parent transition program
• Tuition reimbursement
• Corporate gift matching program

Pay Range : $92,000 - $148,000

The range shown represents a grouping of relevant ranges currently in use at Publicis Sapient. Actual range for this position may differ, depending on location and specific skillset required for the work itself.

As part of our dedication to an inclusive and diverse workforce, Publicis Sapient is committed to Equal Employment Opportunity without regard for race, color, national origin, ethnicity, gender, protected veteran status, disability, sexual orientation, gender identity, or religion.

We are also committed to providing reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures.

TBD - looking for someone with strong SQL skills and familiarity with AWS Redshift, EBX and Data Governance. Do not need to be senior level.

Will be 100% remote, 1 year contract project work. Will update JD once we get more details following our meeting with the manager this afternoon.

Required Skills : SQL skills and familiarity with AWS Redshift, EBX, and Data Governance

Basic Qualification :

Additional Skills :

Background Check : Yes

Drug Screen : Yes

Notes :

Selling points for candidate :

Project Verification Info :

Candidate must be your W2 Employee : No

Exclusive to Apex : No

Face to face interview required : No

Candidate must be local : No

Candidate must be authorized to work without sponsorship : : No

Interview times set : Yes

Type of project : Project Management Office

Master Job Title : Data Analyst

Branch Code : Providence