Data Engineer

Requisition ID 23-28101 Location US-NV-Summerlin Position Type Regular Category Mortgage Operations & Servicing salary $79,000 - $131,500

PENNYMAC

Pennymac (NYSE : PFSI) is a specialty financial services firm with a comprehensive mortgage platform and integrated business focused on the production and servicing of U.

S. mortgage loans and the management of investments related to the U.S. mortgage market.

At Pennymac, our people are the foundation of our success and at the heart of our dynamic work culture. Together, we work towards a unified goal of helping millions of Americans achieve aspirations of homeownership through the complete mortgage journey.

A Typical Day

The Senior SQL Developer will be responsible for design, development, testing, and implementation of a set enterprise level data warehouse systems and solutions.

As the SQL Developer , your responsibilities will also include technical leadership and effective communication, conducting peer code review and suggesting remediation paths, supporting business needs with ad-hoc needs requests and organizing and presenting data to multiple levels of management.

The Senior SQL Developer will :

• Facilitate data retrieval and manipulation through implementation of views, stored procedures, triggers and cursors
• Design and develop ETLs to move data across internal servers and external SFTP utilizing input variables for easier deployment to different environments
• Apply ETL error handling and package logging that stores results into SQL tables for ease of troubleshooting
• Optimize query performance by modifying existing queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing tables objects
• Deploy SSIS packages for ETL using Integration Catalog utilizing input variables for easier deployment to different environments
• Architect ETL enhancements to increase the performance data warehouse using query manager and optimizer
• Perform other related duties as required and assigned
• Demonstrate behaviors which are aligned with the organization’s desired culture and values

What You’ll Bring

• 5+ years of MS SQL database and SQL Information Services knowledge and development experience
• Ability to design, code, test, debug, package and deploy quality, scalable and well documented SQL solutions
• Experience with SSIS, Informatica or other ETL tools
• Programming experience with emphasis on designing complex SQL queries and business components
• Financial Services and, if possible, mortgage industry experience preferred

Why You Should Join

As one of the top mortgage lenders in the country, Pennymac has helped over 4 million lifetime homeowners achieve and sustain their aspirations of home.

Our vision is to be the most trusted partner for home. Together, 4,000 Pennymac team members across the country are guided by our core values : to be Accountable, Reliable and Ethical in all that we do.

Pennymac is committed to conducting a business that makes positive contributions and promotes long-term sustainable growth and to fostering an equitable and inclusive environment, where all employees and customers feel valued, respected and supported.

Benefits That Bring It Home : Whether you're looking for flexible benefits for today, setting up short-term goals for tomorrow, or planning for long-term success and retirement, Pennymac's benefits have you covered.

Some key benefits include :

• Comprehensive Medical, Dental, and Vision
• Paid Time Off Programs including vacation, holidays, illness, and parental leave
• Wellness Programs, Employee Recognition Programs, and onsite gyms and cafe style dining (select locations)
• Retirement benefits, life insurance, 401k match, and tuition reimbursement
• Philanthropy Programs including matching gifts, volunteer grants, charitable grants and corporate sponsorships

To learn more about our benefits visit :

Compensation : Individual salary may vary based on multiple factors including specific role, geographic location / market data, and skills and experience as defined below :

• Lower in range - Building skills and experience in the role
• Mid-range - Experience and skills align with proficiency in the role
• Higher in range - Experience and skills add value above typical requirements of the role

Some roles may be eligible for performance-based compensation and / or stock-based incentives awarded to employees based on company and individual performance.

Salary

$79,000 - $131,500

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later. Share on your newsfeed

Need help finding the right job?

We can recommend jobs specifically for you!

California applicants, please to view our Privacy Policy and to view our Privacy Notice.

Software Powered by iCIMS

Job Title : Programmer Analyst

Salary : $29.74 - $44.76 Hourly

This is not a remote position. Alternative work schedule eligible

As a Programmer Analyst, you will play a crucial role in analyzing the impact of proposed solutions on business applications.

Your responsibilities will include developing, implementing, and maintaining application systems and programs, ensuring their satisfactory functioning through testing, analysis of results, and correction of deficiencies according to business requirements.

Additionally, you will provide application assistance to support technical and operational areas.

Job Requirements :

Education / Experience :

• Bachelor's Degree in computer science, computer information systems, computer programming, or a related field
• Three (3) years of professional experience as an applications or systems programmer / analyst

Licensing / Certification Requirements :

Certification in specific information systems technology programs may be required for certain positions

Additional and / or Preferred Position Requirements :

• Epic Bridges Certification or Proficiency
• Practical knowledge of Health Level 7 protocols and programming methods
• Experience with enterprise interface platforms such as Cloverleaf or CorePoint
• Practical knowledge of Structure Query Language (SQL) standards, data modeling, and programming methods
• Experience coordinating efforts of multi-discipline teams or related experience

Knowledge, Skills, Abilities, and Physical Requirements :

Knowledge of :

• Programming languages such as C++, Visual Basic, RPG, and other generative and contemporary languages
• Structured programming methodology
• Database design methods and support utilities
• Computer programming, data modeling, and object-oriented programming procedures and techniques
• Batch and online applications techniques
• Operating principles and characteristics of various computers and associated hardware
• Job planning, prioritizing, and scheduling techniques
• Department and hospital safety practices and procedures
• Patient rights, age-specific patient care practices, infection control policies and practices
• Handling, storage, use, and disposal of hazardous materials
• Department and hospital emergency response policies and procedures

If you meet the qualifications and are ready to take on this exciting opportunity, please apply using your most recently updated resume.

Thank you!

AppleOne is proud to be an Equal Opportunity Employer. We believe in people, and we are committed to working with people of all backgrounds and connecting them with clients and companies who share our goals of diversity and inclusiveness.

All qualified applicants will receive consideration for employment without regard to race, religion, ancestry, color, national origin, age, gender identity or expression, genetic information, marital status, medical condition, disability, protected veteran status, sex (including pregnancy), sexual orientation, or any other characteristic protected by applicable federal, state, or local laws.

For temporary assignments lasting 13 weeks or longer, the Company is pleased to offer major medical, dental, vision, 401k and any statutory sick pay where required.

Job Posting Title

Senior Analyst Data Insights and Continuous Improvement

Pay Range

$72,083-$133,870

Summary

This role will be a part of the Americas General Ledger team, part of Global Finance Services (GFS), with the purpose of driving a continuous improvement mindset across the team, contributing to process and operational improvements to the team, with an initial focus on Gaming Operations and Game Sales through applying accounting best practices and system knowledge to focus areas, building enhanced reporting, and providing insights to facilitate informed decision-making across the team.

The role will support the strengthening of the culture of continuous improvement and help the GL team improve their processes for both effectiveness and efficiency.

What You'll Do

Assist Manager with creating culture of continuous improvement in the GL team

Continuously meet with GL and other business partners to identify areas for improvement and then help drive solutions that create efficiencies

Applies Americas subject matter expertise to Global GL group this will be especially critical as the rest of the regions transition to D365

Assist with facilitation of Monthly Continuous Improvement sessions and trainings develop training materials and lead trainings

Process intake ideas and report requests submitted through CI portal

Work with Manager and GL leaders to prioritize initiatives

Work with GL team members to gather requirements

Work with Analyst / Specialist of Data Insights when new or updated reporting is needed

Provide accounting expertise and insights to Analyst / Specialist of Data Insights

Take on a mentorship role to the Analyst / Specialist of Data Insights

Gaming Operations and Sales Support

Identifies, develops, and assists with building of reports to support GL team revenue specific requirements

Partner with Billing team and AR to drive Revenue focused improvements

Ad-hoc support to GL team in researching initiatives and resolving issues. Additionally, provide root cause analysis when issues do arise to proactively address to prevent future issues

Finance Systems / ERP

Serve as ERP SME for GL and Continuous Improvement COE teams

Builds and embraces knowledge of the technology eco-systems supporting financial reporting (D365) to identify improvement opportunities to help drive efficiency and process improvement across the GL team

Support global standardization by partnering with EMEA accounting team to identify areas that can be aligned with Americas GL processes.

Support global expansion and standardization by helping to improve EMEA current ERP and identifying improvements to increase efficiency pending EMEA’s future adoption of D365

Data Insights

Works with GL team and stakeholders to identify data insight gaps and builds roadmap to deliver improved insights using various technology tools

Supports troubleshooting of live issues with data and reporting across the team

Challenges data quality and integrity, building program to enhance the robustness of data quality

Inputs GL needs into broader finance transformation initiatives on data to support company efficiency and growth

Transformation Initiatives

Works with Finance Leadership team to review existing end-to-end processes to identify and then implement, integrate, or improve to gain more E.A.S.E. in our processes

Identify opportunities / develop and build the self-serve of data reports to meet team and stakeholder requirements

Support GFS colleagues on broad reporting initiatives and drive combined efforts and definitions sharing best practices

Support Company expansion and growth initiatives by documenting and standardizing accounting processes of newly acquired entities

What We're Looking For

Bachelor’s degree in business, finance, learning science, data analytics, applied analysis psychology, statistics, or a closely related field.

Masters a plus.

Advanced Microsoft Excel skills

Experience with accounting departments and continuous improvement a plus

Skills and Knowledge

Must be able to read, write, speak and understand English.

Must have strong communication skills, be able to work independently and be team oriented.

Must have excellent organizational skills and able to participate in multiple projects

Excellent interpersonal skills required.

Must possess a high level of personal and professional accountability and be able to enlist the cooperation of peer groups involved in common business goals and objectives.

Ability to meet changing demands and to adapt to frequently changing priorities.

Ability to be part of a positive team environment

Proficiency in accounting and financial computer software

LI-JJ1

Why Aristocrat?

Aristocrat is a world leader in gaming content and technology, and a top-tier publisher of free-to-play mobile games. We deliver great performance for our B2B customers and bring joy to the lives of the millions of people who love to play our casino and mobile games.

And while we focus on fun, we never forget our responsibilities. We strive to lead the way in responsible gameplay, and to lift the bar in company governance, employee wellbeing and sustainability.

We’re a diverse business united by shared values and an inspiring mission to bring joy to life through the power of play.

We aim to create an environment where individual differences are valued, and all employees have the opportunity to realize their potential.

We welcome and encourage applications from all people regardless of age, gender, race, ethnicity, cultural background, disability status or LGBTQ+ identity.

We offer a range of flexible working options through all.flex, our flexible hybrid work model and invite you to have a conversation with us about flexible working. EEO M / F / D / V

World Leader in Gaming Entertainment

Robust benefits package

Global career opportunities

Our Values

All about the Player

Talent Unleashed

Collective Brilliance

Good Business Good Citizen

The US based roles may require registration with the Nevada Gaming Control Board (NGCB) and / or other gaming jurisdictions in which we operate.

Job Description

Are you an experienced Tactical Data Link Analyst with demonstrated experience with multi-domain counterfire teams? Then we have an opportunity for you to support the Automated Tactical Targeting and Counterfire Killl-Web Systems (ATTACKS) Quick Reaction Test (QRT).

The ATTACKS QRT team will test and validate tactics, techniques, and procedures (TTP) for tactical operators within the United States Forces Korea (USFK) Counter-Fire Task Force Air Component Command to employ and disseminate counterfire information via the automation provided by ATTACKS to prosecute Long-Range Artillery (LRA) threats efficiently, at scale, and within their vulnerability window during large-scale combat operations.

As a Tactical Data Link Analyst you will :

• Develop, test, and evaluate tactical data link (TDL) TTP to effectively interoperate in support of USFK counterfire mission.
• Interface with Eighth Army, 607th Air Support Operations Group (ASOG), 25TH Fighter Squadron and 210th Field Artillery Brigade for test coordination.
• Participate on a team of driven, supportive and highly skilled professionals.
• Receive a robust benefits package that includes our !
• Enjoy flexibility managing your work hours and personal needs with a single accrual leave plan.

A week in the life of a Tactical Data Link Analyst :

• Generate and execute a test plan to demonstrate TTP using a multi-domain counterfire team, including airborne shooters and surface counterfire platform with the Advanced Field Artillery Tactical Data System connected to ATTACKS.
• Conduct report development, and coordinate project reviews with Service, interagency, and combatant command entities as necessary.
• Support project Team Lead and Technical Director in execution of assessment requirements.
• Support development and evaluation of test plans and event execution documents.
• Support the team in assessment design, the establishment of measures of performance and evaluation, and subordinate test requirements to ensure proper and successful data collection and analysis.
• Offer risk reduction strategies, risk mitigation plans, and fully document existing processes, project enhancements, and test results.

Founded in 1975, AMERICAN SYSTEMS is one of the largest employee-owned companies in the United States. We are a government services contractor focused on delivering Strategic Solutions to complex national priority programs with 100+ locations worldwide.

Through our focus on quality, strong cultural beliefs and innovation we deliver excellence every day.

Company Awards :

• Forbes National Best Midsize Companies
• Energage National Best Workplaces
• Washington Post Best Workplaces

Veteran Hiring Awards :

• U.S. Department of Labor Hire Vets Medallion
• BEST FOR VETS by Military Times
• TOP 10 MILITARY FRIENDLY COMPANY by MilitaryFriendly.com

cjpost

Job Requirements

• 10 years of technical and operational experience with any of the following TDL systems : Automated Tactical Targeting and Counterfire Kill-Web System (ATTACKS);
• Advanced Field Artillery Tactical Data System (AFATDS); Situational Awareness Data Link (SADL); Link-16 Tactical Data Link / J-Series messages;

Tactical Radio Application Extension (TRAX) software; ATAK / WinTak applications; AN / TPQ-53 radar's variable message format (VMF) K-series targeting data messages

• Operational experience in the Korean Theater of Operations (USFK) with any of : 8TH Army, 607TH Air Support Operations Group (ASOG), 25TH Fighter Squadron, 7TH Air Force, 210TH Field Artillery Brigade (FAB), USAF Tactical Air Control Party (TACP)
• SECRET clearance
• Knowledge of Long-Range Artillery (LRA) threat on the Korean peninsula
• Familiarity with Joint Air Ground Integration Center (JAGIC)
• Familiarity with Combined Air Component Commander Wartime Baseline Special Instructions and with Combined Forces Command Publication 3-1-1, Combined Joint Fires
• Knowledge of test planning, data collection, and analysis at the operational and tactical levels.
• Familiarity with test and assessment, operational assessment, demonstration processes, procedures and techniques, design, data collection, and reporting.

EOE Minorities / Women / Disabled / Veterans / Gender Identity / Sexual Orientation or EEO M / W / D / V / GI / SO

World gate recruiter team is looking for a full-time Data Analyst with great experience.

Job Summary

The Data Analyst role requires a strong background in data processing, analysis, and modeling. The ideal candidate will have experience with Microsoft SQL Server, Python, C#, and Microsoft PowerShell.

The qualified person for this position will have a proven successful track record in inspecting, cleansing, transforming, analyzing, and modeling data.

On a day-to-day basis, the Data Analyst will work with our analytics team on new development initiatives, maintenance of the existing platform, and reporting functions.

The Data Analyst will perform these duties while maintaining good communication and reporting relationships with multiple departments, field management, and Company Personnel at all levels.

Duties & Responsibilities

• Work on the continued development of our revenue management platform
• Build internal applications / processes to meet department needs
• Develop reporting using data stored in our business intelligence software
• Link databases from different corporate platforms, including Operations, IT, Accounting, HR, and Property Services
• Other duties as assigned
• Periodic special projects and duties may be assigned based on Company need and requirements

Education / Experience

• Equivalent work experience may be substituted for educational requirements.
• 3+ years of experience in a data analyst role preferred

Skills

• Proficient knowledge of Microsoft SQL Server required
• Proficient knowledge of C# and / or Python required
• Familiarity with machine learning tools a plus.
• Proficient knowledge of Microsoft PowerShell preferred
• Proficient in Microsoft Office Suite - Word, Excel, and Outlook with advanced skills in Excel highly preferred
• Ability to understand and convey Company Policies and relevant industry standards
• Ability to analyze and configure data for reporting purposes
• Excellent computer skills required
• Good written and verbal communication skills
• Good organizational skills
• Collaborative team player
• Proactive, self-starter, goal oriented and ability to work independently
• Ability to effectively communicate while exercising diplomacy, sound judgment, and tact
• Ability to deal effectively with co-workers, department managers, and outside vendors
• Ability to work flexible hours depending on various departmental project deadlines and / or Company events and sponsored programs

Benefits

• Healthcare, Vision, and Dental Insurance
• 20 Days of PTO
• 401K Matching
• Training / Certification Reimbursement
• Short term / Long term disability
• Life Insurance
• $100,000-$120,000 yearly base on experience
• United states applicants only
• No Visa sponsorship

Candidate for this role must be able to start work immediately with our client within two weeks